alter table 表2 add remoteid int
update a set remoteid=b.remoteid from 表1 a inner join 表2 b on a.userid=b.userid

------解决方案--------------------
探讨

引用:
SQL code
alter table 表2 add remoteid int
update a set remoteid=b.remoteid from 表1 a inner join 表2 b on a.userid=b.userid
列名remoteid无效，用insert to可以吗？


------解决方案--------------------
SQL code
----表2增加一列remoteid
alter table 表2 add remoteid int

---将表中remoteid值更新到表2中
update a set remoteid=b.remoteid 
from 表1 a inner join 表2 b on a.userid=b.userid

------解决方案--------------------
SQL code
----表2增加一列remoteid
alter table 表2 add remoteid int

---将表中remoteid值更新到表2中
update a set remoteid=b.remoteid 
from 表2 a inner join 表1 b on a.userid=b.userid