mysql display each day in a month
- by Jason
during a month, display the infor each date, order by date, but this infor is empty in some day. how can i still display each day as a row?
Product  date
-----------------
20     2008-01-01
10     2008-01-02
20     2008-01-03
10     2008-01-05
09     2008-01-08
30     2008-01-09
result:
Product  date
-----------------
20     2008-01-01
10     2008-01-02
20     2008-01-03
0      2008-01-04
10     2008-01-05
0      2008-01-06
0      2008-01-07
09     2008-01-08
30     2008-01-09