*
SELECT * FROM Student WHERE SID NOT IN
(
SELECT DISTINCT Student.SID FROM Student , SC , Course , Teacher
WHERE
Student.SID = SC.SID
AND SC.CID = Course.CID
AND Course.TID = Teacher.TID
AND Teacher.Tname = '张三'
ORDER BY Student.SID
);
Original: https://www.cnblogs.com/OnlyOnYourself-lzw/p/16573925.html
Author: OnlyOnYourself-Lzw
Title: Question08-查询没学过”张三”老师授课的同学的信息
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/581559/
转载文章受原作者版权保护。转载请注明原作者出处!