使用外连接查询信息

查询所有科目的考试信息:
SELECT SubjectName,StudentNo,StudentResult FROM dbo.Subject AS J
LEFT JOIN dbo.Result AS R ON J.SubjectId = R.SubjectId
查询从未考试的科目信息
SELECT SubjectName,StudentNo,StudentResult FROM dbo.Subject AS J
LEFT JOIN dbo.Result AS R ON J.SubjectId = R.SubjectId
WHERE StudentNo IS NULL AND StudentResult IS NULL
查询所有年级对应的学生信息
SELECT GradeName,StudentNo,StudentName FROM dbo.Grade AS G
RIGHT OUTER JOIN dbo.Student AS S ON G.GradeId = S.GradeId
WHERE GradeName = 'Y2'