Earlier in my script I created a table called TABLE1. I want to perform an Outer Join with TABLE2, which has not yet been pulled, and which resides in an OLEDB connection. I cannot get this to happen (basically don't know how), so I thought I’d first bring in this TABLE2 separately, then perform the Outer Join in a subsequent step.
So now I have two tables, TABLE1 and TABLE2. What’s the best way to do an Outer Join on field = PNumber?
I tried doing this with no success:
LOAD * FROM TABLE1;OuterJoinLOAD * FROM TABLE2;
I get an error saying that these tables cannot be found. I’m relatively new to joins, so any help is much appreciated.
My apologies...in my code above I put the wrong table name...I did, in fact, put TableNew in the Outer Join and got the same error. I don't get it...if this code is creating a new table called TableNew by doing the Outer Join, why are we using that table name in the Outer Join statement?