DELETE FROM ITEM
WHERE STOCK_MANAGEMENT_TYPE = 1
AND
(ITEM_CODE IN
(SELECT ITEM_CODE
FROM STOCK
)
OR ITEM_CODE IN
(SELECT ITEM_CODE
FROM STOCK
WHERE LAST_DELIVERY_DATE IS NOT NULL
AND LAST_DELIVERY_DATE < '2022/12/01'
AND ACTUAL_AMT=0)
)