在SQL Server 2008数据库系统中，可以得到和以下语句相同结果的查询语句是（ ）。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 JOIN Score AS C ON (S.SCode=C.StudentID）
B．SELECT S.SName，C.CourseID，C.Score FROM Score AS C JOIN Students AS S ON (C.SCode=S.StudentID)
C．SELECT S.SName，C.CourseID，C.Score FROM Score AS C RIGHT JOIN Students AS S ON (S.SCode=C.StudentID)
D．SELECT S.SName，C.CourseID，C.Score FROM Students AS S LEFT JOIN Score AS C ON (S.SCode=C.StudentID)
