Sql 多表查询更新语句
update tableA
set UID = tableB.UserID
from tableA , tableB
where tableA.UserName=tableB.UserName
Sql 多表查询更新语句
update tableA
set UID = tableB.UserID
from tableA , tableB
where tableA.UserName=tableB.UserName
转载于:https://www.cnblogs.com/yeye518/archive/2011/05/04/2231635.html