有兩個表lms.sap_materialmaster和plant.sap_materialmaster，需要根據MATNR=MATNR AND WERKS=WERKS AND DATAUPDATE=DATAUPDATE這個三個欄位不一樣的修改資料（insert的我已經處理了）
UPDATE lms.sap_materialmaster a
SET MAKTX=:NEW.MAKTX,
...
ZZMTFK=:NEW.ZZMTFK
WHERE a.MATNR =b.MATNR
AND a.WERKS=b.WERKS
and b.dataupdate!=a.dataupdate;
uj5u.com熱心網友回復：
UPDATE lms.sap_materialmaster aSET MAKTX=:NEW.MAKTX,
...
ZZMTFK=:NEW.ZZMTFK
WHERE exists (select 1 from plant.sap_materialmaster b
where a.MATNR =b.MATNR
AND a.WERKS=b.WERKS
and a.dataupdate!=b.dataupdate);
where 里面的條件根據你實際需求寫
uj5u.com熱心網友回復：
UPDATE LMS.SAP_MATERIALMASTER ASET (MAKTX, .. . ZZMTFK) =
(SELECT NEW.MAKTX,.. . NEW.ZZMTFK
FROM PLANT.SAP_MATERIALMASTER
WHERE A.MATNR = B.MATNR
AND A.WERKS = B.WERKS
AND B.DATAUPDATE != A.DATAUPDATE
AND ROWNUM = 1)
WHERE EXISTS (SELECT 1
FROM PLANT.SAP_MATERIALMASTER
WHERE A.MATNR = B.MATNR
AND A.WERKS = B.WERKS
AND B.DATAUPDATE != A.DATAUPDATE)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/242989.html
標籤：基礎和管理
上一篇：有沒有大佬知道這個怎么做啊