Hi

I want to summarise sales by month for a given period for different salespeople so I sum(total) group by yearmonth salesperson etc.

Fine but I also want the months when there are no sales. Whats the best method in sql of getting that .

Anyone ?

Thanks

Nick