I have two tables with payments and deductions. How do I substract the payments from the deductions being in two separate tables ?
I need to take this total:
SELECT SUM (PmtRecd) as totalpayments
and substract this total:
SELECT SUM (amount) AS totaltransactions
And call it "TotalAvailable"