Syntax Query

[livvie]

DELETE *
FROM SQLACCESS.tblctest
WHERE (est_id IN
(SELECT SQLACCESS.tblctest.*
FROM SQLACCESS.tblctest INNER JOIN
SQLACCESS.tblDrawings ON SQLACCESS.tblctest.cid = SQLACCESS.tblDrawings.CID AND
SQLACCESS.tblctest.Partno = SQLACCESS.tblDrawings.Part_no AND
SQLACCESS.tblctest.partname = SQLACCESS.tblDrawings.Part_Name))

Is this the correct synatx to delete records from the tblctest if they match the criteria in the select statement

 

[FoFa]

No:
(SELECT SQLACCESS.tblctest.*
should only return one column, the one that matches est_id, not all columns (*) like you have it.