4 Replies Latest reply: Aug 17, 2017 9:12 AM by Prashanth Reddy RSS

    Concatenate and Left join at same time

    Deepika Shinde

      Hi,

       

      I am trying to use Concatenate and Left Join together.

       

      Below is the Current query:

      A:

      Load

           x,y,z

      from Table1;

       

      Concatenate

      Load

           x,y,z

      Resident Table2;

       

      Now I want to Left Join on Table2 with Table 3

       

      A:

      Load

           x,y,z

      from Table1;

       

      Concatenate

      B:

      Load

           x

      Resident Table 3

       

      Left Join (B)

      Load

           x,y,z

      Resident Table2;

       

      --Gives an error Cannot find table Left Join (B);

       

      Please let me know how to use Concatenate and Left join in the query.