DELETE FROM ITEM AS A WHERE NOT EXISTS (SELECT * FROM STOCK AS B WHERE A.ITEM_CODE == B.ITEM_CODE) AND STOCK_MANAGEMENT_TYPE == 1;
DELETE FROM ITEM AS A WHERE NOT EXISTS (SELECT * FROM STOCK AS B WHERE A.ITEM_CODE == B.ITEM_CODE AND NOT(B.ACTUAL_AMT == 0 AND B.LAST_DELIVERY_DATE <= "2022-11-30")) AND STOCK_MANAGEMENT_TYPE == 1;