查询没学过"张三"老师讲授的任一门课程的学生姓名
仍然还是嵌套,三层嵌套, 或者多表联合查询
select * from student
where student.sid not in(
select sc.sid from sc where sc.cid in(
select course.cid from course where course.tid in(
select teacher.tid from teacher where tname = "张三"
)
)
);
select * from student
where student.sid not in(
select sc.sid from sc,course,teacher
where
sc.cid = course.cid
and course.tid = teacher.tid
and teacher.tname= "张三"
);