1 Reply Latest reply on May 15, 2012 1:52 PM by 934476

    making union all


      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
        • 1. Re: making union all
          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.