SQL——delete left join

代码如下

DELETE
    a
FROM
    t_StorageQty a
LEFT JOIN
    t_Item b
ON
    a.F_ItemID = b.F_ID
WHERE
    isnull(b.F_ID,'') = ''

 

posted @ 2020-05-04 18:55  法宝  阅读(4839)  评论(0)  编辑  收藏  举报