1 Reply Latest reply: May 15, 2012 8:52 AM by 934476 RSS

    making union all

    770542
      Hi,

      i trying to prepare an interface below. i am using dataset for making union all but i couldnt understand how can i make sum at the result.


      select name,sum(count) from
      (
      select name,count from TABLE1
      union all
      select name,count from TABLE2
      )

      thank you
      Ugur
        • 1. Re: making union all
          934476
          Hi Ugur,


          I think you should do that in two different interfaces.

          The first one for the union all between the two datasets and the second one for the aggregation.
          If the first one is a temporary interface you can check the "Use temporary interface as Derived Table (Sub-Select)" option so it will produce the same query you posted.


          Hope it helps.


          Regards