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