2 Replies Latest reply: Mar 27, 2017 3:13 PM by Ruytter Mendonça RSS

    How to concatenate after joining?

    Ruytter Mendonça

      Hi guys! I need some help from you.

       

      I have 4 tables, and i'm joining them in pairs, and I need to concatenate one pair with the other.

      Is something like this:

       

      Table1A

           Load

           ....

           From X

      Left join (Table1A)

      Table2A

           Load

           ....

           From X

       

      Table1B

           Load

           ....

           From X

      Left Join (Table1B)

      Table2B

           Load

           ....

           From X

       

      Now I want to concatenate the joined Table1B with Table1A and make just one table.
      If I use the concatenate between Table2A and Table1B the Left Join (Table1B) command is not executed because Table1B is concatenated with Table1A.

       

      Any thoughts?

      Thanks