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;