SELECT sno,sname FROM student s where not exists
(select * from course where course.tno=
(select tno from teacher where teacher.tname=
查询学过“叶平”老师所教的所有课的同学的学号、姓名
最新推荐文章于 2023-01-12 12:22:03 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
SELECT sno,sname FROM student s where not exists
(select * from course where course.tno=
(select tno from teacher where teacher.tname=