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 ;)
Sunday, February 26, 2012
error in delete query
Labels:
database,
delete,
error,
microsoft,
mysql,
oracle,
query,
server,
spsid,
spsidwhere,
sql,
tblpickingslip,
tblpickingtask
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment