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>>