Need help with a join for a resident table

[#1]

Cant wrap my head around this... I would like to create a temp table called Incremental, using columns from Balance, and a single column from Rate (ask). Can anyone point out how I should do this? I want to use Incremental to fill in a straight table...

Balance:
SQL SELECT REPORT_MONTH,
ID,
CURRENCY
FROM mydb.dbo."BALANCE";

Rate:
SQL SELECT REPORT_MONTH,
CURRENCY,
ASK
FROM mydb.dbo."RATES";

Incremental:
LEFT JOIN (Rate)
LOAD Balance._ID,
Balance.CURRENCY,
Rate.ASK
RESIDENT Balance;

[#2]

Why not:

Incremental:

Noconcatenate

Load * Resident Balance;

Left Join

Load * Resident Rate;

Drop Tables Balance,Rate;

The two tables will be joined based on REPORT_MONTH and CURRENCY field;

[#3]

If i am qualifying, do i need to add the source table names before the column names?

[#4]

In that case you can just unqualify the two fields that are used for joining. It will be

Qualify *;

Unqualify REPORT_MONTH, CURRENCY ;