Hi I have the below as sql output.
but i want updates to be displayed as Sum of updates and Multibases. It should be like the below.
the query i used for the first output is
SELECT type, SUM(Update_Count) FROM Scope1 where type in ('Updates','Multibases','DAIS','Acds','Legis','LegAll') and (RECVD_DATE >='04/02/2012' and RECVD_DATE <='11/30/2012') group by type
please help me how do i get the second output.