SELECT st.s_id,st.s_name,c.c_name,sc.s_score FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
LEFT JOIN course c ON c.c_id =sc.c_id
ORDER BY st.s_id,c.c_name
-- 35、查询所有学生的课程及分数情况;
最新推荐文章于 2022-12-08 14:06:17 发布
SELECT st.s_id,st.s_name,c.c_name,sc.s_score FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
LEFT JOIN course c ON c.c_id =sc.c_id
ORDER BY st.s_id,c.c_name