Delete query gives error from JOIN 1

[smuthcrmnl777]

When I try to execute this Delete query, I get an error asking me to specify which table I want to Delete. I want to delete the data that match Query2 from tM_FR_WIP_UnitID_FastStops.

DELETE tM_FR_WIP_UnitID_FastStops.nLine
FROM Query2 INNER JOIN tM_FR_WIP_UnitID_FastStops ON Query2.EndGroup = tM_FR_WIP_UnitID_FastStops.EndGroup
WHERE (((tM_FR_WIP_UnitID_FastStops.nLine) Is Not Null));

 

[gmmastros]

Remove the field name from the Delete clause.

DELETE tM_FR_WIP_UnitID_FastStops
FROM Query2 INNER JOIN tM_FR_WIP_UnitID_FastStops ON Query2.EndGroup = tM_FR_WIP_UnitID_FastStops.EndGroup
WHERE (((tM_FR_WIP_UnitID_FastStops.nLine) Is Not Null));

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[PHV]

DELETE tM_FR_WIP_UnitID_FastStops.[!]*[/!]
FROM tM_FR_WIP_UnitID_FastStops INNER JOIN Query2 ON tM_FR_WIP_UnitID_FastStops.EndGroup = Query2.EndGroup
WHERE tM_FR_WIP_UnitID_FastStops.nLine Is Not Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886