数据表T1(id,name),T2(id,name),需要set t1.name=t2.name where t1.id=t2.id，怎样实现好？
------解决方案--------------------
试试这个:
update t1
set t1.name=t2.name
from T2
where t1.id=t2.id
------解决方案--------------------
update t1
set t1.name=t2.name
from t2
where t1.id=t2.id
------解决方案--------------------
update a set a.name = b.name from T1 a,T2 b where a.id=b.id