Join

[nikhilgarg]

I have 3 tables.

I put:

Table 1 Right Join Table2;

Table3  Right Join Table 2;

Now how can i make  output of Table1 (right join) output of Table3 ?

thanks

[Gysbert_Wassenaar]

Table1:

LOAD * FROM Source1

right join (Table1)

LOAD * FROM Source2

right join (Table1)

LOAD * FROM Source3

[nikhilgarg]

Hey,

I mean :

Table1:

LOAD * FROM Source1

right join (Table1)

Table2:

LOAD * FROM Source2

then i do

Table3:

LOAD * FROM Source3

right join (Table2)

LOAD * FROM Source2

Now , how can i do Resultant Table1   right join Resultant Table3  because i think i have to reload all data again ?