把表1的remoteid列添加到表2里面的sql语句如何写

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

----表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