simple join question

[#1]

Hello All,

I'm having troubles doing an outer join, I thought I understood and it's easy but I get an error. I want to do an outer join for Table1 and 2. These tables have a key that make them connected to each other, but now I want to have everything from the two tables in one NewTable and then drop the first two tables. Below gives me an error

NewTable:

outer join(Table1)

load * from Table2;

[#2 · Accepted solution]

oh I need to use load * resident and not from!!!! Apologies