S>select A.Name, sumB, sumC
S>from A 
S>left join (select AID, sum(count) as sumB from B group by AID) BG on BG.AID = A.ID
S>left join (select AID, sum(count) as sumB from C group by AID) CG on CG.AID = A.ID
S>