两表内连接查询信息

来源：互联网发布：淘宝店铺第三方编辑：程序博客网时间：2024/06/12 01:01

查询学生姓名,所属年级名称及联系电话

SELECT GradeName,StudentName,Phone FROM dbo.Grade AS G INNER JOIN dbo.Student AS S ON (G.GradeId = S.GradeId)查询年级编号为1的年级名称,科目名称及学时SELECT GradeName,SubjectName,ClassHour FROM dbo.Grade AS G INNER JOIN dbo.Subject AS J ON (G.GradeId = J.GradeId) WHERE G.GradeId = 1查询参加科目编号为1的考试的学生姓名,分数,考试日期SELECT StudentName,StudentResult,ExamDate FROM dbo.Student AS S INNER JOIN dbo.Result AS R ON (R.StudentNo = S.StudentNo ) WHERE R.SubjectId = 1查询学号为S1101007的学生参加的考试科目名称,分数,考试日期SELECT SubjectName,StudentResult,ExamDate FROM dbo.Subject AS J INNER JOIN dbo.Result AS R ON (J.SubjectId = R.SubjectId) WHERE R.StudentNo = 'S1101007'查询参加考试的学生学号,所考科目名称,分数,考试日期SELECT StudentNo,SubjectName,StudentResult,ExamDate FROM dbo.Result AS R INNER JOIN dbo.Subject AS J ON (R.SubjectId = J.SubjectId)

0 0