7-9.sql

SQL2000跟课件学习的源代码 分享共同学习

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