Common filed across table

[Prabhu1204]

Hello 

Could you clear  me the below Question?

I have five tables  1,2,3,4,5 and fields name as below

Table 1 : 

A,

B,

C

Table 2:

B,

C,

D,

Table 3 :

C,

D,

E,

F,

Table 4:

f,

g,

h,

i

Table 5:

A,

B,

G,

H,

I

All table have more than one or two same column name with each other table. In this case will join works or how to built a data model. I need output from al 5 tables

[dieterwoestemeier]

Hi Prabhu,

The Join will create a table with all possible combinations. Try something like this:

MasterTable:
NoConcatenate
Load
A,B,C
Resident
Table1;
join
load
B,C,D
Resident
Table2;
join
load
C,D,E,F
Resident
Table3;
...

drop tables Table1, Table2, Table3, ...;

If you want to exclude records that didn't match with the previously loaded table, consider using the left join.

I often use join, inner join and left join in one hit, depending on what I want to achieve.