7-20.sql

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

USE Educational
GO
SELECT S.StudentID, S.StudentName, CourseName, Grade
FROM  Grade G
INNER JOIN Student S ON S.StudentID = G.StudentID
INNER JOIN Course C ON C.CourseID = G.CourseID
WHERE S.ClassID = '030501'
ORDER BY S.StudentID, CourseName