>> >>SELECT *, >> CASE >> >> WHEN PAY_REC = 'REC' AND (NOTSHIP > CASH_BAL OR (NOTSHIP < CASH_BAL AND CASH_BAL > 0) >> THEN CASH_BAL - NOTSHIP >> >> WHEN PAY_REC = 'PAY' AND (NOTSHIP > CASH_BAL OR (NOTSHIP < CASH_BAL AND CASH_BAL > 0) >> THEN CASH_BAL > ELSE 0 >> >> END AS Ar >> >>FROM Trades >>