Hep with a delete Query.

[JHNielson]

I have two Tables - [ERR_REC] and [STG_INPT] the both have fields [REC_ID]

I want to find records in ERR_REC that match ones in STG_INPT and delete those records from ERR_REC

I have used the following query:

DELETE ERR_REC.*, STG_INPT.REC_ID
FROM ERR_REC LEFT JOIN STG_INPT ON ERR_REC.REC_ID = STG_INPT.REC_ID
WHERE (((STG_INPT.REC_ID) Is Not Null));

But when I run it I get a "Could not delete from specified files"

I'm not sure why.

Can anyone help here?

[MMcCarthy]

Returning the REC_ID from the STG_INPT table was causing the problem. This should work ...

DELETE ERR_REC.*
FROM ERR_REC LEFT JOIN STG_INPT 
ON ERR_REC.REC_ID = STG_INPT.REC_ID
WHERE (((STG_INPT.REC_ID) Is Not Null));
 

Mary