日期:2014-05-18 浏览次数:20513 次
update A set A.name = B.name from A join B on A.id=B.id
------解决方案--------------------
或這樣用
update A,B set A.name = B.name where A.id=B.id
------解决方案--------------------
update A,B
set A.name = B.name
where A.id=B.id
------解决方案--------------------
update a set name=b.name from a ,b whre a.id=b.id
------解决方案--------------------
update a set a.name=b.name from a inner join b on a.id=b.id
------解决方案--------------------
update t1 a inner join 查询5 b on a.a1=b.a1 set a.a2=b.a2