I have a table that has the following fields:
Cust_ID, Name, Address1, Zip
I need to find duplicated records that have the same Name Address1 and Zip and dump them into another table that has the same fields. These records can have different Cust_ID's which was caused by users adding the same information into this table multiple times causing records with identical name/address info to have different Cust_ids. I need to eliminate this by having only 1 record per customer.
How do I do this?
Any info will help