34,575
社区成员
发帖
与我相关
我的任务
分享
select a.stu_id,a.stu_name,a.stu_age,sum(b.info_score) info_score from 用户表 a , 分数表 b where a.stu_id = b.stu_id group by a.stu_id,a.stu_name,a.stu_age
select
a.stu_id , a.stu_name, a.stu_age,b.info_score
from
用户表 a
left join
(select stu_id,sum(info_score) from 分数表 group by instu_idfo_id)b
on
a.stu_id=b.stu_id
select a.stu_id , stu_name, stu_age,info_score=sum(info_score )
from 用户表 a,
分数表 b
where a.stu_id=b.stu_id
group by a.stu_id , stu_name, stu_age