Subtract two fields values from two different tables

[seband_fredes]

Hi everyone, I've two tables:

T1:

T2:

I need to apply an JOIN and subtract Cash fields value between T1 and T2. The join Table's result is:

Any idea?.

Thans for all, blessings

[dplr-rn · Accepted solution]

Something like below

T1Temp:
load 
 Eq
 ,Region
 ,Cash as Casht1
from T1Source;

left join(T1Temp)
load 
 Eq
 ,Region
 ,Cash as CashT2
from T2Source;


load  Eq
 ,Region
 ,Casht1-CashT2 as Cash
resident T1Temp;

drop table T1Temp;