DELETE FROM ITEM
WHERE
(
SELECT 1 FROM ITEM

LEFT OUTER JOIN STOCK

WHERE 0 = 0
AND STOCK.ITEM_CODE IS NULL

OR (LAST_DELIVERY_DATE >= date('2023-06-01','-6 month')
AND ACTUAL_AMT = 0)

AND STOCK_MANAGEMENT_TYPE = 1


)