个人收藏
鼎捷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' )