anchoredwisdom
Starting Member
22 Posts |
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, Products A,B,C,D 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.)
Best Regards S |
|