joined deleting

[trustsun]

I get the error: Specify the table containing the records you want to delete. Here’s the SQL:

DELETE tblcarrier.Store#, tblcarrier.Request, tblcarrier.Date, tblPkupNoCmp.ACT
FROM tblcarrier INNER JOIN tblPkupNoCmp ON tblcarrier.Store# = tblPkupNoCmp.Store#
WHERE tblPkupNoCmp.ACT="NoInfo" Or (tblPkupNoCmp.ACT<>"OK";


I’m trying to delete records from table tblPkupNoCmp that is joined to table tblcarrier and I get the error above. How can I revise this?

 

[Remou]

Do you mean something like:

DELETE * FROM tblPkupNoCmp
WHERE (tblPkupNoCmp.ACT="NoInfo"
OR tblPkupNoCmp.ACT<>"OK")
AND tblPkupNoCmp.Store#
IN (Select Store# From tblCarrier);

I hope I have that right, but best check.