多條件刪除。
DELETE CUSTOMS_BILL_ITEM_FAIL F
WHERE (F.BILL_NO,F.SOURCE_BILL_NO,F.INSPECT_BILL_NO, F.ITEM_NO )
IN (SELECT BILL_NO,SOURCE_BILL_NO, INSPECT_BILL_NO, ITEM_NO
FROM CUSTOMS_BILL_ITEM_TEMP
WHERE COMMODITY_NO IS NOT NULL
AND SOURCE_COUNTRY IS NOT NULL
AND LIST_NO IS NOT NULL)
DELETE CUSTOMS_BILL_ITEM_FAIL F
WHERE (F.BILL_NO,F.SOURCE_BILL_NO,F.INSPECT_BILL_NO, F.ITEM_NO )
IN (SELECT BILL_NO,SOURCE_BILL_NO, INSPECT_BILL_NO, ITEM_NO
FROM CUSTOMS_BILL_ITEM_TEMP
WHERE COMMODITY_NO IS NOT NULL
AND SOURCE_COUNTRY IS NOT NULL
AND LIST_NO IS NOT NULL)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16429119/viewspace-669772/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
