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));