已知关系S(S#,SN,AGE,SEX),SC(C#,S#,GRADE),C(C#,CN,TEACHER)。若要检索学生姓名及其选修课程的课程号和成绩,正确的SELECT语句是()
A. SELECT S.SN,SC.C#,SC.GRADE FROM S WHERE S.S#=SC.S#
B. SELECT S.SN,SC.C#,SC.GRADE FROM S,SC WHERE S.S#=SC.S#
C. SELECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADE
D. SELECT S.SN,SC.C#,SC.GRADE FROM S.SC