学生表 :Student(S(学号),Sname(姓名),Sage(年龄),Ssex(性别))课程表 :Course(C(课程编号),Cname(课程名称),T(教师编号))成绩表 :SC(S(学号),C(课程编号),score(分数))教师表 :Teacher(T(教师编号),Tname(姓名))
问题:查询没学过"张三"授课的同学的信息
收起
select st.* from Student st where not exists (select 1 from SC, Course c, Teacher t where st.s = sc.s and sc.c = c.c and t.t = c.T# and t.T = '01');
报告相同问题?