update 更新查询出的表字段

update tableB   set tableB.a ='aaa' 
 from (
  SELECT *  FROM tableA 
 ) as tableB  

/*普通的更新数据方法*/

update table set a='aaa'