I have two tables "Master List" and "Audit". I want to delete the records from the "Master" that match those in the "Audit". I am using Access 2010 and have used it often but have built very few queries. Consider me a beginner please.
Thank you jdraw. If i understand this correctly this is deleting from one table and know value. I am wanting to delete from one table using matching unique value from another table. What am I missing?
With databases and SQL
--you insert records INTO 1 table at a time.
--you UPDATE existing records in 1 table at a time
--you DELETE records from 1 table at a time.
Are you working with sample/test data?
First do a Select query first.
The general format of the Select query will be something like the following:
Code:
Select table1.*
, table2.*
FROM
table1 inner join table2
where
table1.uniquefld = table2.uniquefld
Substitute your table names and unique field names as appropriate.
By using the SELECT query, you will not do any updates/deletes from your tables.