create function Course_Teacher(@course_name varchar(255)) returns table as return (select C.* from Course as C,Teacher as T where C.CNO=T.CNO and C.CNO in (select CNO from Course where CNAME=@course_name) 报错误如下，请大家帮助我看看！ 消息 102，级别 15，状态 1，过程 Course_Teacher，第 10 行 ')' 附近有语法错误。
createfunction Course_Teacher(@course_namevarchar(255))
returnstableasreturn (select C.*from Course as C,Teacher as T
where C.CNO=T.CNO
and C.CNO in (select CNO from Course where CNAME=@course_name)[color=#FF0000])[/color]
