SELECT to DELETE

  • Thread starter Thread starter Chad
  • Start date Start date
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
 
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])));
 
Back
Top