Concatenate tables resulted from Left Joins

[avantime]

Hi

Is it possible to quickly concatenate two tables like this?

(

Load  *

From dbA;

Left Join

Load *

From dbB;

)

Concatenate

(

Load  *

From dbC;

Left Join

Load *

From dbD;

)

I mean I know the syntax is not correct but I figure that there must be a faster way to do it rather than creating separate temporary tables and concatenating them together afterwards.

[stascher]

Have you tried

Table1:

Load  *

From dbA;

Left Join

Load *

From dbB;

concatenate(Table1)

Load  *

From dbC;

Left Join

Load *

From dbD;

[avantime]

Hi Steven,

Thank you for your reply.

I knew about this method, but the last left join will look something like:

((

Load  *

From dbA;

Left Join

Load *

From dbB;

)

Concatenate

Load  *

From dbC;

)

Left Join

Load *

From dbD;

Please check attached example;

[krishna_2644]

Hi - As you are loading from different tables from different data sources, you have to have multiple joins to establish proper relation.There's no faster way as far as i know unless the fields are common or data sources are common.

May be other experts might have good knowledge on this.