Sql两个表互相更新

表：a,b

字段：a.id,a.fid,a.name

         b.id,b.name

update a set a.name=b.name from b where a.fid=b.id