---存在しないのを削除







DELETE FROM ITEM 
WHERE ITEM_CODE IN
(

SELECT ITEM_CODE FROM (
SELECT ITEM_CODE,MAX(ifnull(LAST_DELIVERY_DATE, '2099-99-99')) maxdate
,max(ACTUAL_AMT) maxamt
FROM STOCK
GROUP BY ITEM_CODE
) A
WHERE maxdate < '2022-12-01'
AND maxamt >0
UNION
SELECT ITEM_CODE FROM ITEM A
WHERE NOT EXISTS
(
SELECT *
FROM STOCK
WHERE A.ITEM_CODE =STOCK.ITEM_CODE
)
)
AND STOCK_MANAGEMENT_TYPE ='1';