I have two tables that contain the same fields: LoanNumber, LoanAmount
I need a query that gives me all records where the LoanNumber matches, but the LoanAmount is different.
What's wrong with my code below? Thanks!
select LoanNumber, loanamount
where (tableA.LoanNumber in
(select loannumber from tableB)
and tableA.loanamount <> tableB.loanamount)