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