SELECT R.StudentNo AS 学生学号,S.StudentName,J.SubjectName AS 考试科目名称,R.StudentResult AS 成绩
FROM Result AS R
INNER JOIN Subject AS J ON (R.SubjectId = J.SubjectId)
INNER JOIN Student AS S ON (S.StudentNo = R.StudentNo)
-------------------------------------------------------------------------
SELECT S.StudentName AS 学生姓名,R.StudentResult AS 成绩,R.ExamDate AS 考试日期
FROM Result AS R
INNER JOIN Subject AS J ON (R.SubjectId = J.SubjectId)
INNER JOIN Student AS S ON (S.StudentNo = R.StudentNo)
WHERE J.SubjectName='走进Java编程世界'
07-29