0 Replies Latest reply: Nov 1, 2012 6:39 AM by user9093300 RSS

    Sum two different types in same column

    user9093300
      Hi I have the below as sql output.

      TYPE SUM(UPDATE_COUNT)
      Legis 93
      Acds 43
      Updates 41
      Multibases 345

      but i want updates to be displayed as Sum of updates and Multibases. It should be like the below.

      Updates 386

      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.

      Thanks