update a1 set a1.字段 = 值 where a1.键 = (select a2.键 from a join b on (ab关联) join c (ac关联或bc关联) where b条件或c条件 )