11上机练习4

USE MySchool--查询学生学号、姓名、考试科目名称及成绩。SELECT S.StudentNo AS 学号,S.StudentName AS 姓名,J.SubjectName AS 科目名称,R.StudentResult AS 成绩FROM Result AS RINNER JOIN Student AS S ON(R.StudentNo=S.StudentNo)INNER JOIN Subject AS J ON(R.SubjectId=J.SubjectId)SELECT S.StudentNo AS 学号,S.StudentName AS 姓名,J.SubjectName AS 科目名称,R.StudentResult AS 成绩FROM Result AS R,Student AS S,Subject AS JWHERE(R.StudentNo=S.StudentNo) AND (R.SubjectId=J.SubjectId)--查询参加“走进Java编程世界”考试的学生姓名、成绩、考试日期。SELECT S.StudentName AS 姓名,R.StudentResult AS 成绩,R.ExamDate AS 考试日期FROM Result AS RINNER JOIN Student AS S ON (R.StudentNo=S.StudentNo)INNER JOIN Subject AS J ON(R.SubjectId=J.SubjectId)WHERE J.SubjectName='走进Java编程世界' SELECT S.StudentName AS 姓名,R.StudentResult AS 成绩,R.ExamDate AS 考试日期FROM Result AS R, Student AS S ,Subject AS JWHERE(R.StudentNo=S.StudentNo) AND (R.SubjectId=J.SubjectId)AND J.SubjectName='走进Java编程世界'