Hello Good Afternoon,
Can you please help me with below query how to get the another column in the output as (First_Bal - S_Balance) ?
SELECT
COL1, Col2, Col3, First_Bal, First_Qty, S_Balance
--- New Column which is First_bal - S_Balance here how???
FROM (
SELECT COL1, Col2, Col3, SUM(Balance) First_Bal,
Sum(Quantity) First_Qty, 0 as S_Balance
from Table2
Group by COL1, Col2, Col3
UNION ALL,
SELECT COL1, Col2, Col3, 0 First_Bal, 0 First_Qty,
SUM(MyBalance) as S_Balance
from Table1
Group by COL1, Col2, Col3
)
Thank you in advance
ASita
SELECT
COL1, Col2, Col3, First_Bal, First_Qty, S_Balance
, First_bal - S_Balance AS New_Balance
FROM (
SELECT COL1, Col2, Col3, SUM(Balance) First_Bal,
Sum(Quantity) First_Qty, 0 as S_Balance
from Table2
Group by COL1, Col2, Col3
UNION ALL,
SELECT COL1, Col2, Col3, 0 First_Bal, 0 First_Qty,
SUM(MyBalance) as S_Balance
from Table1
Group by COL1, Col2, Col3
)