List:General Discussion« Previous MessageNext Message »
From:Ryan Liu Date:January 10 2011 11:51pm
Subject:how to generate a data set then join with in on fly?
View as plain text  
Hi,

In MySQL, is that possible to generate a data set join with it on fly (without 
create an temporary table)?

e.g. for a report used by a graphic tool, it requires data in all dates, even it 
is null. Can I

select vacationT.* left join ( all dates d in the past 3 years) on 
vacationT.`date` = d  ?

Thanks,
Ryan


      
Thread
how to generate a data set then join with in on fly?Ryan Liu11 Jan
  • Re: how to generate a data set then join with in on fly?MySQL)11 Jan
    • Re: how to generate a data set then join with in on fly?Nuno Tavares12 Jan