在sql server2008数据库系统中,可以的到和以下语句相同结果的查询语句是() select students.sname,score.courseid,score.score from students,score where students.scode=score.studentid
A.
select s.sname,c.courseid,c.score from students as s inner join score as c on s.scode=c.studentid
B.
select s.sname,c.courseid,c.score from score as c inner join students as s on s.scode=c.studentid
C.
select s.sname,c.courseid,c.score from score as c right outer join students as s on s.scode=c.studentid
D.
select s.sname,c.courseid,c.score from students as s left outer join score as c on s.scode=c.studentid