以下是两个表: Student( Student_ID , Name, Domitory, Tuition) Course ( Course_ID , Title, Building, Room, Year, Semester, Student_ID) 现在要给用户列出学生姓名(name)以及其所选课程的名称(title),其查询过程的中间产物如下: (Student_ID, Name, Domitory, Tuition, Course_ID, Title, Building, Room, Year, Semester, Student_ID) 请问下列哪个查询语句是正确的
A.
select Name, Title from Student, Course;
B.
select Name, Title from Student, Course where Student.Student_ID = Course.Student_ID;
C.
select Name, Title from Student Nature Join Course;
D.
select Name, Title from Student, Course where Student_ID = Student_ID;