How to concatenate 2 joined tables from 2 sources

[dee_patil]

Hi,

We need to achieve below. Can somebody please help? 

A:
Load
C1,
C2
From QVD1;

Inner Join (A)
Load
C1,
C2
B:
Select
C1,
B1
From Table1;

C:
Load
C1,
C2
From QVD2;

Inner Join (C)
Load
C1,
C2
D : 
Select
C1,
D1
From Table2;

//Now we want to achieve below

concatenate A and C

Basically I need to concatenate 2 joined tables from 2 sources.

Thanks,

Dee

[mato32188 · Accepted solution]

HI @dee_patil,

A:
Load
C1,
C2
From QVD1;

Inner Join (A)
Load
C1,
B1;
SQL
Select
C1,
B1
From dbTable1;

noconcatenate
C:
Load
C1,
C2
From QVD2;

Inner Join (C)
Load
C1,
D1;
SQL Select
C1,
D1
From dbTable2;

noconcatenate

Final:

Load * resident A concatenate Load * resident C; drop tables A,C;

BR

m

[dee_patil]

Thanks a lot Mato32188 for quick response. I will try this solution and will update.

Thanks,

Dee