create table tot_segment_st SELECT s.rule, s.ix, count(r.id) as n_res, sum(r.n_sn) as n_sn, sum(r.n_kf) as n_kf, count(ro.odlk) as n_odlk, s.minl FROM tot_segment s left join tot_result r on s.id=r.segment left join tot_result_odlk ro on ro.segment=s.id and ro.result=r.id group by s.id;