I have two tables. TableA and TableB which contains customer records. The records are split over the two tables like so:
TableA contains a customers FirstName and LastName
TableB contains the customers Address
Both tables are connected through CustomerID
I want to do a select of all the customers that are duplicates i.e. the fields FirstName, LastName, and Address are the exact same in the duplicated records.
Anyone know how I could do this as the customer records are split across two tables A and B ?