SELECT
st.*,
sc.s_score AS '语文',
sc2.s_score AS '数学'
FROM
student st
LEFT JOIN score sc ON sc.s_id=st.s_id AND sc.c_id='01'
-- 2、查询“01“课程比“02“课程成绩低的学生的信息及课程分数
最新推荐文章于 2022-07-19 23:32:42 发布
SELECT
st.*,
sc.s_score AS '语文',
sc2.s_score AS '数学'
FROM
student st
LEFT JOIN score sc ON sc.s_id=st.s_id AND sc.c_id='01'