Sorry, I see that wasn't as clear as it needed to be. Need to keep ALL records from both tables, but match where there is a match between Loan Number and New Loan Number. The problem is that not every Old Loan Number has a New Loan Number, so matching on Loan Number and New Loan Number alone loses records. Again trying to keep track of 1) all loans in current inventory, 2) all those that have paid off and 3) those that have been paid off and customer recaptured as new loan.
