DELETE FROM ITEM
WHERE
(
SELECT ITEM.* FROM ITEM

LEFT OUTER JOIN 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))

)