I have table that includes a column of CHARGES and also includes a column of PAYMENTS both with data for customer billing. Do I need 2 select statments then compare them together to determine if the account has a balance?
I am uncertain as to the best way SUM the each field and then compare to each other to determine if one as a balance.
Any help would be appreciated.
TIA!
RPP
I am uncertain as to the best way SUM the each field and then compare to each other to determine if one as a balance.
Any help would be appreciated.
TIA!
RPP