Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks a lot Mato32188 for quick response. I will try this solution and will update.
Thanks,
Dee