Delete Query where code and client are equal

[marlind]

I am trying to delete a record in tblinclude where record from tblexclude are equal to clientid and codeid

Here is the sql
DELETE tblinclude.ClientID
FROM tblexclude INNER JOIN tblinclude ON (tblexclude.ClientID = tblinclude.ClientID) AND (tblexclude.CodeID = tblinclude.CodeID)
WHERE (((tblinclude.ClientID)=1));

I get the error Specify the table containing the records you want to delete. I've searched for this but I am just not getting it today. Thanks for any help.

 

[CJ_London]

Access doesn't understand which table you want to delete records - is it the include or the exclude table?

DELETE tblinclude.ClientID
FROM tblexclude INNER JOIN tblinclude ON (tblexclude.ClientID = tblinclude.ClientID) AND (tblexclude.CodeID = tblinclude.CodeID)
WHERE (((tblinclude.ClientID)=1));

I think what you want is

DELETE * FROM tblInclude
WHERE Exists(SELECT * FROM tblExclude as Tmp WHERE clientID=tblInclude.ClientID AND CodeID=tblInclude.CodeID)=True