Posted - 11/09/2012 : 11:58:51
| Hi Gurus,
I have a table with four columns.
ProductID, Year, Product , amount.
only 4 years , 4 products , 4 Ids , 4 amounts
say years 2009,2010,2011,2012,
ProductID,1,2,3,4 AND respective amounts,
now i just want sum (amounts ) group by these three attributes
But for 2010 Product C did not do any business hence there is no record for year 2010 against C id 3
I have display null against that missing year,id,product
( I tried to put my scenario in a generic way.)