■

id name

1 anken1

2 anken2

3 anken3

id ankenid code name

1 1 1 ko1-1

2 1 2 ko1-2

3 1 3 ko1-3

4 2 2 ko2-1

5 2 3 ko2-2

6 2 5 ko2-3

id ankenid kazu

1 1 1

2 1 2

3 1 3

4 2 2

5 2 3

select
a.id, min(b.code),x.q
from
anken a left join anken2 b on a.id = b.ankenid

left join (
select
a.id as p, sum(c.kazu) as q
from
anken a left join sum c on a.id = c.ankenid
group by a.id
) as x on a.id = x.p

group by
a.id