UPDATE
kbgb k1
SET
k1.d001 =
(
SELECT
k2.d001
FROM
kbgb02 k2
WHERE
k1.kdlh = k2.kdlh
AND
k1.xyear = k2.xyear
AND
k1.xcode = k2.xcode)
WHERE
EXISTS (
SELECT
1
FROM
kbgb02 k2
WHERE
k1.kdlh = k2.kdlh
AND
k1.xyear = k2.xyear
AND
k1.xcode = k2.xcode)
update (select a.sal asal,b.sal bsal,a.comm acomm,
b.comm bcomm from emp a,emp1 b where a.empno = b.empno) set asal = bsal, acomm = bcomm;