Problem with Delete query

[Jim Devenish]

I have two tables InputData and CommonData each with three fields F1
(Long integer), F2 (Date/Time), F3 (Text) i.e. the tables have
identical design. I am trying to delete all rows from InputData which
have their F1 value in CommonData as well. This means I wish to leave
in InputData only those rows which are not also in CommonData

When I try to use the Sql:
Delete InputData.* From InputData
Inner Join CommonData On InputData.F1 = CommonData.F1

I get the error message:
'Could not delete from specified tables'

Both tables are local and are not in use by any other form or query.

Can I delete these commmon rows? and if so, how?

 

[Allen Browne]

Try a subquery:

DELETE FROM InputData
WHERE EXISTS
(SELECT F1 FROM CommonData
WHERE CommonData.F1 = InputData.F1);

If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066