十一章 上机3

SELECT S.StudentName AS 学生姓名,G.GradeName AS 年级名称,S.Phone AS 联系电话
FROM Student AS S
INNER JOIN Grade AS G ON (S.GradeId = G.GradeId)

-------------------------------------------------------------------------
SELECT G.GradeName AS 年级名称,J.SubjectName AS 科目名称,J.ClassHour AS 学时
FROM Subject AS J
INNER JOIN Grade AS G ON (J.GradeId = G.GradeId)
WHERE G.GradeId = 1

-------------------------------------------------------------------------
SELECT S.StudentName AS 学生姓名,R.StudentResult AS 分数,R.ExamDate AS 考试日期
FROM Student AS S
INNER JOIN Result AS R ON (S.StudentNo = R.StudentNo)
WHERE R.SubjectId=1

-------------------------------------------------------------------------
SELECT J.SubjectName AS 考试科目名称,R.StudentResult AS 分数,R.ExamDate AS 考试日期
FROM Result AS R
INNER JOIN Subject AS J ON (R.SubjectId = J.SubjectId)
WHERE R.StudentNo = 'S1101007'

-------------------------------------------------------------------------
SELECT R.StudentNo AS 学生学号,J.SubjectName AS 考试科目名称,R.StudentResult AS 分数,R.ExamDate AS 考试日期
FROM Result AS R
INNER JOIN Subject AS J ON (R.SubjectId = J.SubjectId)