how to resident load two fields from different tables?

[Anonymous]

I have 2 tables loaded already, table1, table2.

Now want to resident load field [store name] from table1, another field [month] from table 2,

what is the correct syntax? thanks.

[sunny_talwar · Accepted solution]

May be this:

NewTable:

LOAD CommonFields

          [Store Name]

Resident Table1;

Join (NewTable)

LOAD CommonFields

          Month

Resident Table2;