Remove duplicates from two tables based on one field

[fboehlandt]

Hi everyone,
i would like ot eliminate duplicate entries from two tables. Both tables contain a field called name which is unique within each table but may have duplicate observations across the two tables. The other field entries may not be identical. Consequently, a UNION query does not eliminate the doubles. I would like to retain one of the two values, say from Table 1. The Table 2 entry can be eliminated if it has the same name. The 'find duplicate query' yields all duplicates instead of removing them (note that I ran a UNION query first to combine the two tables). I essentially require the oposite of the 'find duplicate' query. Any help please...

 

[apr pillai]

Since, Union Query is of no help here, there is no quick solution to this. But, if you link both tables on the common field and create output of matching records from both tables separately. Inspect the output records and eliminate the unwanted records manually.
OR
Use the Key field + other matching field contents as link for Delete Query to remove the records from one of the tables.