数据库表格处理。A表与B表中在若干条件下的数据匹配

update A set a5=(select b6 from B where a1=b1 and a2=b2 and a3=b3) where exists (select 1 from b where a1=b1 and a2=b2 and a3=b3)