SELECT st.s_id,c.c_name,st.s_name,sc.s_score FROM student st
INNER JOIN score sc ON sc.s_id=st.s_id AND sc.s_score<60
INNER JOIN course c ON c.c_id=sc.c_id
-- 37、查询不及格的课程
最新推荐文章于 2023-01-10 17:58:07 发布
SELECT st.s_id,c.c_name,st.s_name,sc.s_score FROM student st
INNER JOIN score sc ON sc.s_id=st.s_id AND sc.s_score<60
INNER JOIN course c ON c.c_id=sc.c_id