子表sum

select   master.id,master.date,master.name,sum(sub.number)
from   master,sub
where   master.id=sub.id
group   by   master.id,master.date,master.name