select a.人åå§å,b.æ»éå®,c.æ»è±è´¹ from 人å表 a
left join
(select 人åid,sum(éå®éé¢) æ»éå® from éå®è¡¨ group by 人åid) b
on a.人åid=b. 人åid
left join
(select 人åid,sum(è±è´¹éé¢) æ»è±è´¹ from è±è´¹è¡¨ group by 人åid) c
on a.人åid=c. 人åid
温馨提示:答案为网友推荐,仅供参考