SELECT
st.*,
sc.s_score
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
WHERE sc.c_id='01' AND sc.s_score<60
ORDER BY sc.s_score DESC ;
05-08
5400
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
SELECT
st.*,
sc.s_score
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
WHERE sc.c_id='01' AND sc.s_score<60
ORDER BY sc.s_score DESC ;