Sunday, February 26, 2012

error in delete query

What is the problem in :
DELETE FROM tblPickingTask
LEFT OUTER JOIN tblPickingSlip ON tblPickingTask.SPSID = tblPickingSlip.SPSID
WHERE tblPickingSlip.SPSID IS NULL
I whan to delete all record in tblPickingTask was not in tblPickingSlipTry this:

DELETE FROM tblPickingTask
FROM tblPickingTask
LEFT OUTER JOIN tblPickingSlip ON tblPickingTask.SPSID = tblPickingSlip.SPSID
WHERE tblPickingSlip.SPSID IS NULL|||How about this?

DELETE tasks FROM tblPickingTask tasks
LEFT OUTER JOIN tblPickingSlip slip
ON tasks.SPSID = slip.SPSID
WHERE slip.SPSID IS NULL|||Originally posted by rdjabarov
How about this?

DELETE tasks FROM tblPickingTask tasks
LEFT OUTER JOIN tblPickingSlip slip
ON tasks.SPSID = slip.SPSID
WHERE slip.SPSID IS NULL ;)

No comments:

Post a Comment