SQL Code in Query?

  • Thread starter Thread starter Gary
  • Start date Start date
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
 
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

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

Back
Top