On Thursday 24 April 2008 12:26:09 pm Gary Greenberg wrote:
> 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.
Make a new list of just dates then join them both together.
--
Regards,
Michael Cole
LPIC-1
"The man who does not read good books has no advantage over the man who can't
read them. "
- Mark Twain
"It is our choices, Harry, that show what we truly are, far more than our
abilities."
— J. K. Rowling
"Wear the old coat and buy the new book."
— Austin Phelps
"I'm not a teacher: only a fellow traveler of whom you asked the way. I
pointed ahead – ahead of myself as well as you."
— George Bernard Shaw
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
