General information
Forum:
Microsoft SQL Server
Hi
this is actually a Mysql query.
I have a table with a range of yearmonths (say 200501 to 200702)
and a table with yearmonth,model_id,amount_sold with some yearmonths for some models missing if none where sold in the month.
I want a query which gives me all yearmonths in my range, all models and amounts_sold including 0 months where none of a particular model has been sold.
Any thoughts on the easiest way to achieve that.
Thanks
Nick
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only