Sql 多表查询更新语句

Sql 多表查询更新语句

update tableA
set UID = tableB.UserID 
from tableA , tableB 
where tableA.UserName=tableB.UserName