Gary Greenberg schrieb:
I have a table that stores performed transactions and I need to build a
histogram of a number of transactions per day in the requested period.
So, I made a simple query with the group by clause which returns me what
I need:
2008-04-16 65456204
2008-04-17 190838546
2008-04-18 8909047
2008-04-19 9085084
2008-04-21 18221038
2008-04-22 18246184
except that there is no entry for April 20th as there were no
transactions at that day. I need a query to return me zero for that day.
I.e. I need uninterrupted sequence of dates.
I am beating my head at this problem for the whole day and did not make
much of a progress. If someone has any idea how to resolve this problem,
I'll appreciate a tip greatly.
a similar question was just answered on this list about 15 hours before your
question ...
http://lists.mysql.com/mysql/212457
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]