SELECT to DELETE

C

Chad

I would like to convert a SELECT statement to a DELETE
statement and I am having some trouble.

Here is my SELECT statement (that works):

SELECT CIM_CONDUCTOR.*
FROM CIM_CONDUCTOR LEFT JOIN CIM_LINEEND ON
CIM_CONDUCTOR.OBJECTID = CIM_LINEEND.FK_CONDUCTOR
WHERE (((CIM_CONDUCTOR.OBJECTID) Not In ([CIM_LINEEND].
[FK_CONDUCTOR])));

Any suggestions?

Thanks,

Chad
 
J

John Spencer (MVP)

What trouble are you having? Error message, nothing happening, burning
computer? You might try.

DELETE CIM_CONDUCTOR.*
FROM CIM_CONDUCTOR LEFT JOIN CIM_LINEEND ON
CIM_CONDUCTOR.OBJECTID = CIM_LINEEND.FK_CONDUCTOR
WHERE (((CIM_CONDUCTOR.OBJECTID) Not In ([CIM_LINEEND].
[FK_CONDUCTOR])));
 
Top