DELETE FROM ITEM AS I
WHERE 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-01-01' AND ACTUAL_AMT=0);