查询每个学生及其选修课程的情况(不包括没有选修课程的学生),以下语句正确的为( )(SQL SERVER平台中)
A.
SELECT Student.Sno, Sname, Ssex, Sage, Sdept, Cno, score FROM Student right join sc on(student.sno=sc.sno)
B.
SELECT Student.Sno, Sname, Ssex, Sage, Sdept, Cno, score FROM Student left join sc on(student.sno=sc.sno)
C.
SELECT Student.Sno, Sname, Ssex, Sage, Sdept, Cno, score FROM Student right out join sc on(student.sno=sc.sno)
D.
SELECT Student.Sno, Sname, Ssex, Sage, Sdept, Cno, score FROM sc left out join Student on(student.sno=sc.sno)