33 Replies Latest reply: Aug 20, 2014 9:16 AM by neetha P RSS

    UNION ALL in SELECT Statement

    neetha P


      Hi all,

       

      Please advise on UNION All in Select query,How to use:

       

      Select

      Details1 as Details,

      a,

      b,

      c

      From A

       

      UNION ALL

      Select

      Details2 as Details,

      a,

      b,

      c

      From B;

       

      Above statement is not working in load script.

      I want to extract data with a select statement

      for performance tuning.

       

      Thanks for help

       

      Nitha