Delete query (1 Viewer)

[pdbowling]

Hi all
I have a small table with a list of items that I would like to delete from a larger table. All column names and settings are the same.

I tried to set up a query to do this but have been unsuccessful.

I tried

"Delete * from table1 where table1.field1 = table2.field1 and table1.field2 = table2.field2"
to which I am asked "Specify the table to delete from.

If I try to join them it really gets confused.
Anysuggestions?
PB

 

[cogent1]

Join the two tables on both fields that have to correspond. Do this using the query grid for ease. If you want to use SQL switch to SQL view and paste into your code.