SELECT s.* FROM student s WHERE s.s_id NOT IN(
SELECT
st.s_id
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
LEFT JOIN course c ON c.c_id
-- 8、查询没学过“张三“老师授课的同学的信息
最新推荐文章于 2022-08-27 22:58:39 发布
SELECT s.* FROM student s WHERE s.s_id NOT IN(
SELECT
st.s_id
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
LEFT JOIN course c ON c.c_id