Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;