Sql 多表查询更新语句
update tableA set UID = tableB.UserID from tableA , tableB where tableA.UserName=tableB.UserName