Oracle从一张表更新到另一张表update

个人收藏

鼎捷T100，从请购单更新工单信息

update sfaa_t set (sfaa019,sfaa020)=(SELECT pmdb030,pmdb030 from sfab_t 
LEFT JOIN  PMDB_T ON PMDBENT=15 AND PMDBSITE='dahe' AND  PMDBDOCNO=SFAB002 AND PMDBSEQ=SFAB003 
WHERE SFABDOCNO=SFAADOCNO AND SFAB002='T111-21090019'  and SFAAstus='N'  ) 
where exists (select 1  from sfab_t 
LEFT JOIN  PMDB_T ON PMDBENT=15 AND PMDBSITE='dahe' AND  PMDBDOCNO=SFAB002 AND PMDBSEQ=SFAB003 
WHERE SFABDOCNO=SFAADOCNO AND SFAB002='T111-21090019'  and SFAAstus='N' );


update  sfba_t set (sfbaua038,sfbaua039)=(SELECT pmdb030 ,pmdb030 from sfab_t 
LEFT JOIN  PMDB_T ON PMDBENT=15 AND PMDBSITE='dahe' AND  PMDBDOCNO=SFAB002 AND PMDBSEQ=SFAB003
LEFT JOIN  SFAA_T ON SFAAENT=15 AND SFAASITE='dahe' AND  SFAADOCNO=SFABDOCNO
WHERE SFABDOCNO=SFbADOCNO AND SFAB002='T111-21090019' and SFAAstus='N' ) 
where exists (select 1  from sfab_t 
LEFT JOIN  PMDB_T ON PMDBENT=15 AND PMDBSITE='dahe' AND  PMDBDOCNO=SFAB002 AND PMDBSEQ=SFAB003
LEFT JOIN  SFAA_T ON SFAAENT=15 AND SFAASITE='dahe

 - List item

' AND  SFAADOCNO=SFABDOCNO
WHERE SFABDOCNO=SFbADOCNO AND SFAB002='T111-21090019' and SFAAstus='N' )