有三张桌子
Student (口碑,姓名,年龄,地址)Course (信用委员会,信用委员会)Student_Course (SCID,STUDID,COURSEID)如何显示某一特定学生的注册学分?
下面是关于表格的详细信息
发布于 2019-04-21 18:01:45
您应该使用联接、SUM()和group by
select a.STUDID, a.NAME, sum(b.CREDIT)
from Student a
inner join Student_Course c on a.STUDID = c.STUDID
inner join Course b on c.COURSEID = b.COURSEID
group by a.STUDID, a.NAME https://stackoverflow.com/questions/55785197
复制相似问题