SELECT st.*,c.c_name,sc.s_score,t.t_name FROM student st
INNER JOIN score sc ON sc.s_id=st.s_id
INNER JOIN course c ON c.c_id=sc.c_id
-- 40、查询选修“张三“老师所授课程的学生中,成绩最高的学生信息及其成绩
最新推荐文章于 2022-11-10 13:57:02 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
SELECT st.*,c.c_name,sc.s_score,t.t_name FROM student st
INNER JOIN score sc ON sc.s_id=st.s_id
INNER JOIN course c ON c.c_id=sc.c_id