>
> A sample of the current results data would be like
> date sales
> 2008-03-07 100.00
> 2007-03-10 150.00
> 2007-03-18 50.00
>
> and what I'm trying to do is fill in the missing dates with sales
> values of 0.
what I do is have a table called days that is the left side of a left
join.
I'm not proud of this, but it works well.
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping