update query

update a set a.name = (select new from b where a.name = b.new
 and b.name = 'a')
where exists
 (select new from b where a.name = b.new and b.name = 'a')