7-19.sql

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

USE Educational
GO
SELECT S.StudentID 学号, S.StudentName 姓名, Co.CourseName 课程, G.Grade 成绩
FROM Grade G
  INNER JOIN Student S  ON  S.StudentID = G.StudentID
  INNER JOIN Class C ON C.ClassID = S.ClassID
  INNER JOIN Speciality_Course SC ON C.SpecialityID = SC.SpecialityID
 and SC.CourseID=G.CourseID
  INNER JOIN Course Co ON Co.CourseID = G.CourseID
WHERE  C.ClassID = '030501'  and  SC.Term = 5