多表关联删除

来源:互联网 发布:宿舍用品淘宝店 编辑:程序博客网 时间:2024/06/11 17:48
DELETE (from) wf
FROM dbo.WFApprove_Path_bak wf
INNER JOIN dbo.[User] u ON u.UID = wf.UID
WHERE wf.ItemID = 'CE-20131129-031' AND u.UID = 1148