更新两张表对应数据的方法

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;