How to Left Join() a table with another below?

[Mattia]

Hi,

if i have 2 tables like the following:

TABLE1:

...

TABLE2:

...

How can i Lef Join() TABLE1 with TABLE2 if the first table is before the second in the script?

I can't change the order of the tables because i need to insert an expression in TABLE2 that involve also some fields of TABLE1.

Please, anyone have a suggest?

Thanks,

Mattia

[bharathadde · Accepted solution]

TABLE1:

...

TABLE2:

...

left join

Load

...

Resident TABLE1;

Basically bring TABLE1 again as a resident load below TABLE2 and then drop TABLE1 if necessary or to avid Synthethic keys.

Hope this helps