If I do
SELECT COUNT(*) as NUMBERRESULTS from amsuser.car
I return 82 results, but if
SELECT COUNT(*) as NUMBERRESULTS from amsuser.car left join amsuser.custhist RW on loan.CUST_NUMBER = RW.cust_number AND loan.ACCOUNT_NUMBER = RW.ACCOUNT_NUMBER AND RW.trans_code='AJ' AND loan.LOAN_CODE='RW'
left join amsuser.custhist RO on loan.CUST_NUMBER = RO.cust_number AND loan.ACCOUNT_NUMBER = RO.ACCOUNT_NUMBER AND RO.trans_code='RG' AND loan.LOAN_CODE='RW'
I get 812 results? How can the joins be adding rows?