在SQL Server 2005中,假定一个学生选修课管理系统中有两个表,包括:student(学生)表,其结构为:sID (),sName (姓名); studentCourse (学生选课)表,其结构为:sID (),cID (课程编号),score (成绩 )。那么列出所有已选课学生的、姓名、课程编号和成绩的SQL语句是(选两项)
A.
SELECT sID,sName,cId,score FROM student,studentCourse
B.
SELECT,sID,sName,cID,score FROM student INNER JOIN studentCourse ON
student.sID = studentCourse.sID
C.
SELECT,sID,sName,cID,score FROM student OUTER JOIN studentCourse ON
student.sID = studentCourse.sID
D.
SELECT,sID,sName,cID,score FROM student, studentCourse WHERE student.sID = studentCourse.sID