当PMBVNDP2的字段MBVNCD 与VNDPT 相等时,将VNDPT的三个字段赋值给PMBVNDP2
UPDATE WLEILIB/PMBVNDP2 AS A
SET (A.MBLTFL,A.MBCTR,A.MBCDT) =
( SELECT B.MBLTFL , B.MBCTR , B.MBCDT
FROM WLEILIB/VNDPT AS B
WHERE A.MBVNCD = B.MBVNCD )
WHERE A.MBVNCD IN
(SELECT MBVNCD
FROM WLEILIB/VNDPT
)