試題詳解

32)查詢学生姓名及其所选修课程的课程号和成绩，正确的SQL语句是
(A)SELECT S.SNAME, SC.C#, GRADE FROM S WHERE S.S#=SC.S#
(B)SELECT S.SNAME, SC.C#, GRADE FROM SC WHERE S.S#==SC.S#
(C)SELECT S.SNAME, SC.C#, GRADE FROM S,SC WHERE S.S#=SC.S#
(D)SELECT S.SNAME, SC.C#, GRADE FROM S,SC WHERE S.S#=SC.C#