7-9.sql

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

SELECT S.StudentName As 姓名, C.CourseName As 课程名, Grade As 成绩
FROM Grade G 
INNER JOIN Student S ON G.StudentID = S.StudentID
INNER JOIN Course C ON G.CourseID = C.CourseID