update A t1 set t1.saile= (
select sum(t.saile) saile from B t
left join C m on t.id= m.id
where m.name in (‘xxx’,‘xxx’,‘xxx’,‘xxx’,‘xxx’)
and t.id= t1.id
group by t.id)
where t1.saile is null
解释:
更新A表中的saile字段为空的记录
saile来源于B表中多条记录之和
t.id= t1.id 就是A表与B表主键的关联