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
 
Back
Top