请教Sql Server语句

Question

select students.name,studies from students,teacher where
    (students.teaches=teachers.name) and (teachers.teachied="教授")

Answer 1

select students.name,students.studies from students,teacher where
    (students.teaches=teachers.name) and (teachers.teachied="教授") 

Answer 2

select students.name,students.studies from students,teacher where
    (students.teaches=teachers.name) and (teachers.teachied="教授") 

Answer 3

sql.text:='select students.name,student.studies from "students","teacher" where students.teachers=teachers.name) and (teachers.teachied="教授")';

Answer 4

SELECT S.name ， S.studies FROM students AS S JOIN teacher AS T ON S.teaches = T.name AND S.teachied = "教授"  
我的比他们的短，西西