Question how to delete rows that match other rows in different table

[roi8877]

Searched but to no avail to what appears should be a simple delete thing.

I have 2 tables which I can easily create a select query, relate 3 columns together and view their records. Nice. Now change that to a delete query and run, I get the message "Specify the table containing the records you want to delete" ....

sql view :

DELETE table1.CountyCode, table1.way, table1.distance
FROM table1 INNER JOIN table1_dups ON (table1.distance = table1_dups.distance) AND (table1.way = table1_dups.way) AND (table1.CountyCode = table1_dups.CountyCode);


What might be the issue?

 

[Galaxiom]

Try this as the first line.

DELETE table1.*