Sending non duplicates from two tables to a new table

[Guest]

I have a customer list and a non customer list. These list contain many
duplicates. How can I search for the duplicates in the two files and have the
noncustomers remaining after the duplicate search be added to a new
table/file?

 

[Rick B]

Why not combine them into one table and add a checkbox for the customers?