Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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