Update a set a.NickName=b.name FROM AccountsInfo a, TT b where a.UserID=b.userId
必须要有关联的两个表
来源: http://www.bubuko.com/infodetail-3135555.html