DELETE FROM ITEM
WHERE ITEM.ITEM_CODE IN
(
SELECT ITEM.ITEM_CODE FROM ITEM
LEFT OUTER JOIN (SELECT ITEM_CODE,STOCK_TYPE,ACTUAL_AMT,LAST_DELIVERY_DATE FROM STOCK 
GROUP BY ITEM_CODE,STOCK_TYPE) STOCK
ON ITEM.ITEM_CODE = STOCK.ITEM_CODE
WHERE 0 = 0
AND STOCK_MANAGEMENT_TYPE = 1
AND (STOCK.ITEM_CODE IS NULL
OR LAST_DELIVERY_DATE <= date('2023-06-01','-6 month') AND ACTUAL_AMT = 0)
)