DELETE FROM ITEM AS I
WHERE NOT EXISTS
(SELECT ITEM_CODE FROM STOCK AS S WHERE S.ITEM_CODE = I.ITEM_CODE);
DELETE FROM ITEM AS I WHERE EXISTS
(SELECT S.ITEM_CODE FROM STOCK AS S WHERE S.ITEM_CODE = I.ITEM_CODE
AND I.STOCK_MANAGEMENT_TYPE = 1
AND LAST_DELIVERY_DATE <= date('2023-06-01', 'localtime', '-6 months')
AND ACTUAL_AMT = 0);