Unable to Delete After Unmatched Query

[Ksabai]

The Following is my Sql, iam able find the record to delete but iam unable to delete as its Says "Specify the table Containing the records you want to delete"

DELETE tblBciCMiA.ContNo, tblBciCMiA.InvNo, tblBciCMiA.Seller, tblBciCMiA.Buyer, tblBciCMiA.Qty, tblBciCMiA.Cert, tblBciCMiA.RQty, tblBciCMiA.RDate, qryBciCMiA.qInvNo
FROM tblBciCMiA LEFT JOIN qryBciCMiA ON tblBciCMiA.[InvNo] = qryBciCMiA.[qInvNo]
WHERE (((qryBciCMiA.qInvNo) Is Null));

 

[arnelgp]

like it says, which table to delete?
obviously from tblBciCMiA.

DELETE tblBciCMiA.* FROM tblBciCMiA LEFT JOIN qryBciCMiA ON tblBciCMiA.[InvNo] = qryBciCMiA.[qInvNo]
WHERE (((qryBciCMiA.qInvNo) Is Null));

!!!BACKUP first your table!!!

 

[June7]

There is no need to specify fields in DELETE because entire record is deleted.

If Arnel's suggestion doesn't work, try:

DELETE FROM tblBciCMiA WHERE ID IN (SELECT ID FROM tblBciCMiA LEFT JOIN qryBciCMiA ON tblBciCMiA.[InvNo] = qryBciCMiA.[qInvNo]
WHERE qryBciCMiA.qInvNo Is Null);

Deleting data should be a rare event. Why are you deleting?

 

[Ksabai]

it works, iam actually just trying how to delete a record.

 

[arnelgp]

he, he, the best place to practice with thrill and chill is on live data!