SQL Code in Query?

G

Gary

I'm trying to run a DELETE query and am getting the
following error:

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

I have a INNER JOIN with Table1.ID and Table2.ID with
Table1.ID as the only field in the DELETE query. I
suspect that the JOIN is causing the issue and may need to
use a SQL SELECT Statement as the criteria for Table1.ID
field rather than a JOIN (if this will work).

Can anyone help with the coding on this? Thanks.

Gary
 
M

Michel Walsh

Hi,


Since there are two tables, you need to specify from which table you
delete the records.


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

How does one report a bug in Access 2007 SQL? 4
Delete Query Question 1
Specify the table containing the records you want to delete 9
Create a distinct Join 3
Query on two tables with matching null fields 4
Making a Delete Qiuery from an unmatched Query 3
wildcard symbols around a field in a join? 6
Delete Query Error 1

Top