7-28.sql

来自「SQL2000跟课件学习的源代码 分享共同学习」· SQL 代码 · 共 13 行

USE Educational
GO
SELECT *
FROM Teacher
WHERE  TeacherID  IN (/* 子查询: 第五学期在030501班上课的教师ID */
  SELECT  CS.TeacherID /* 取教师ID */
  FROM Speciality_Course  SC
  INNER JOIN  CurriculumSchedule  CS ON CS.CourseID = SC.CourseID
  INNER JOIN  Class  C ON SC.SpecialityID = C.SpecialityID  AND  CS.ClassID = C.ClassID
  WHERE  CS.ClassID='030501' /* 设置班级ID */
    AND  SC.Term=5 /* 第5学期 */
  )