![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
在 SQLServer2000 中,假定一个学生选修课管理系统中有两个表,包括: 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