Delete Query Error

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
 
M

Michel Walsh

Hi,


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



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Specify the table containing the records you want to delete 9
How does one report a bug in Access 2007 SQL? 4
Making a Delete Qiuery from an unmatched Query 3
Query on two tables with matching null fields 4
Delete Query Question 1
Create a distinct Join 3
SQL Code in Query? 1
DELETE query 2

Top