Delete One Table from Another Table

[Guest]

1) Table One is legacy table with multiple duplicates in a critical field
("mnemonic field").

2) Table Two is a make table of "mnemonic" duplicates in Table One
(identified via the "find duplicate query wizard."

3) How do I delete all records and fields contained in "Table Two" from the
records contained "Table One"

4) The desired result is to eliminate all convert the critical field
(mnemonic) described in #1 to a future primary key field.

 

[[MVP] S.Clark]

With a Delete query, you can add two tables to it, link them, then specify
the "From" table, which is where the records will be deleted, and the
"Where" table, which contains the criteria for the delete.

So, create a query as you would normally, add the tables, then link them.
Change the query to a delete query (Query / Delete from the main menu), then
specify your From and Where tables.

 

[Guest]

Thank you for your response.

I need help with the SQL set-up, i.e. Please explain the SQL terminology of
how to add the tables and for set-up of the "Delete from [table two] where
[table one = mnemonics]. The essense of this query is to delete duplicate
records in table one.

Thanks again

Quan