(rf.rmstranamt) - (select rf.rmstranamt FROM RMASTER rm
INNER JOIN RFINANL rff ON rff.RMSFILENUM = rm.RMSFILENUM
where rff.RMSTRANCDE = '10') AS [Current Balance],
FROM RMASTER rm
INNER JOIN RFINANL rf ON rf.RMSFILENUM = rm.RMSFILENUM
GROUP BY rm.rmsacctnum

something wrong with how I'm trying to calculate the subtraction here. I'm not sure the syntaxt to include the divisor in this particular situation. I need to subtract from the rmstranamt where rmstrancde is 10 and there should only be one results for the divisor


This is what I need in my results:

Current Balance and Account Number should be retrieved where

Current Balance = Sum of rmstranamt - (sum of rmstranamt where rmstrancde is 10)

Is that equivalent to
Current Balance = (sum of rmstranamt where rmstrancde <> 10)
? If so, would that make your query less complicated?