DELETE FROM ITEM AS I 
WHERE STOCK_MANAGEMENT_TYPE=1 AND 
(NOT EXISTS 
    (SELECT
        ITEM_CODE
    FROM
        STOCK AS S
    WHERE
        I.ITEM_CODE = S.ITEM_CODE)
OR EXISTS
    (SELECT
        ITEM_CODE
    FROM
        STOCK AS S
    WHERE
        I.ITEM_CODE = S.ITEM_CODE AND LAST_DELIVERY_DATE < '2023-12-01' AND ACTUAL_AMT=0));