17,377
社区成员
发帖
与我相关
我的任务
分享
update a
set a.addr1 = (select c.addr2 from b, c where a.id01 = b.id01 and b.id = c.id)
where exitsts(select * from b, c where a.id01 = b.id01 and b.id = c.id)
update a
set a.addr1 =
(select c.addr2
from b, c
where a.id01 = b.id01
and b.id = c.id);