How to concatenate after joining?

[mendoncart]

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

[CarlosAMonroy · Accepted solution]

Hi Ruytter,

What you can do is the following:

After joining the tables. Do this:

NoConcatenate

Table1A_1B:

Load *

Resident Table1A;

concatenate (Table1A_1B)

Load *

Resident Table1B;

drop Tables Table1A, Table1B;

Hope that helps,

Carlos M

[mendoncart]

Hey Carlos,

It worked fine!

Thank you so much for your support and your time!

Have a wonderful week!

[richard_cook]

This solution helped me as well. Thanks for posting it!