Just use the principle of closure: the result of a set based operation is a
set:
SELECT C.CLIENT_NUMBER, C.FIRST_NAME, C.LAST_NAME
, T.cash , T.check , (T.cash + T.check) AMT
FROM client_data C
(SELECT CLIENT_NUMBER
, SUM(DECODE,DEPOSIT_TYPE, 'CASH',DEPOSIT_AMOUNT,0) cash
, SUM(DECODE,DEPOSIT_TYPE, 'CASH',0,DEPOSIT_AMOUNT) check
from (SELECT CLIENT_NUMBER,DEPOSIT_TYPE,DEPOSIT_AMOUNT
FROM west_coast
UNION ALL
SELECT CLIENT_NUMBER, DEPOSIT_TYPE,DEPOSIT_AMOUNT
FROM west_coast
)
GROUP BY CLIENT_NUMBER) T
WHERE T.CLIENT_NUMBER = C.CLIENT_NUMBER
Received on Mon Jun 07 1999 - 22:21:54 CDT
