-- 大概这样 update B set (b.XM, b.BH) =(select A.XM, A.BH from A where A.ID = B.ID) where exists(select * from A where A.ID = B.ID)
UPDATE B SET (XH,XM) = ( //其他字段省略 SELECT XH,XM FROM A WHERE ID=40049A ) WHERE ID=5EC18C
我试了下这样是可行的。UPDATE B B1 SET (B1.XH, B1.XM,B1.BH,B1.MC,B1.XZ,B1.FS,B1.ZF) = (SELECT A1.XH, A1.XM,A1.BH,A1.MC, A1.XZ, A1.FS, A1.ZF FROM A A1 WHERE B1.ID= A1.ID) WHERE B1.ID= (SELECT A2 .IDFROM A A2 WHERE B1.DEPTNO = A2 .DEPTNO)
update B
set (b.XM, b.BH) =(select A.XM, A.BH from A where A.ID = B.ID)
where exists(select * from A where A.ID = B.ID)
SET (XH,XM) = ( //其他字段省略
SELECT XH,XM
FROM A
WHERE ID=40049A
)
WHERE ID=5EC18C
SET (B1.XH, B1.XM,B1.BH,B1.MC,B1.XZ,B1.FS,B1.ZF) =
(SELECT A1.XH, A1.XM,A1.BH,A1.MC, A1.XZ, A1.FS, A1.ZF FROM A A1 WHERE B1.ID= A1.ID)
WHERE B1.ID=
(SELECT A2 .IDFROM A A2 WHERE B1.DEPTNO = A2 .DEPTNO)