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'
-- 1、查询“01“课程比“02“课程成绩高的学生的信息及课程分数
最新推荐文章于 2024-05-12 04:43:39 发布
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'