日期:2014-05-16 浏览次数:20945 次
update a
set a.addr1 =
(select c.addr2
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)
where exitsts(select * from b, c where a.id01 = b.id01 and b.id = c.id)