Delete Query Error

  • Thread starter Thread starter G
  • Start date Start date
G

G

I'm having a problem with a Delete Query ... getting the
error:

"Specify the table containing the records that you want to
delete".

I have an INNER join on table1.ID and table2.ID. The only
field in the query is table1.ID.

I may need to include a SQL select statement instead of a
join (if that's possible) as the criteria ... can anyone
help with this?

Thanks.

G
 
Hi,


DELETE DISTINCROW tableName.* FROM tableName INNER JOIN otherTable ON
.... WHERE ...



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top