Re: selet sql statement

[KimSeong Loh]

Create another table containing all the dates that you want, then do a left join.

Eg, CREATE TABLE dates (period DATETIME);

INSERT into dates value ('2004-03-01 00:00:00'),('2004-04-01 00:00:00'), ....

SELECT t.param1, t.chartdata, t.selected, d.period
FROM dates AS d LEFT JOIN table as t USING (period);


Anyway, this is not related to transactions, please post in the appropriate forum.