求 SQL 2005 中第11章11-1正确代码？
各位大虾：教材中原代码意为建立创建一个能同时反映学生与老师信息的视图，书中原代码如下：
use school
go
create view v_student_teacher
as
select s.id as 'student_id',
s.name as 'student_name',
s.gender as 'student_gender',
s.age as 'student_age',
s.grade,
s.class,
s.teacher_id as 's_teacher_id',
s.parents_id,
s.graduation,
s.city,
c.cardno,
t.id as 'teacher_id',
t.name as 'teacher_name',
t.gender as 'teacher_gender',
t.age as 'teacher_age',
t.subject,
t.teaching_age,
t.position,
t.salary,
from student as s
inner join
teachers as t on s.teacher_id=t.id
go
执行时总是提示：
消息 156，级别 15，状态 1，过程 v_student_teacher，第 22 行
关键字 'from' 附近有语法错误。
求各位大虾们给指正，谢谢！
