初学者 麻烦求助一个SQL语句 显示 ORA-00936: missing expression

Question

语句如下：CREATE VIEWSTUDENT_DETAILS
AS SELECT
TITLE_LOOK_UP.TITLE_NAME AS "Title",
STUDENT.FIRST_NAME AS "First name" ,
STUDENT.LAST_NAME AS "Last name",
ADDRESS.ADDRESS_LINE1 AS "ADDRESS LINE1",
ADDRESS.ADDRESS_LINE2 AS "ADDRESS LINE2",
ADDRESS.ADDRESS_LINE3 AS "ADDRESS LINE3",
ADDRESS.POST_CODE AS "POST CODE",
ADDRESS.CITY AS "CITY",
FROM ADDRESS,  COURSE, TITLE_LOOK_UP, STATUS_LOOK_UP , STUDENTWHERE 
COURSE.COURSE_TITLE = 'Information Management'       and  
STATUS_LOOK_UP.STATUS_DESC = 'in progress'           and 
STUDENT.COURSE_ID=COURSE.COURSE_ID                   and 
STUDENT.OVERALL_STATUS_ID= STATUS_LOOK_UP.STATUS_ID  and 
STUDENT.TITLE_ID=TITLE_LOOK_UP.TITLE_ID              and 
STUDENT.CORRESPONDENCE_ADDRESS_ID=ADDRESS.ADDRESS_ID 显示 ORA-00936: missing expression
执行显示这个 不知道哪里错了。。建表都是没有错的。。也都存在内容非常感谢

Answer 1

CREATE VIEW STUDENT_DETAILS--view与后面的名称分开
AS SELECT
TITLE_LOOK_UP.TITLE_NAME AS "Title",
STUDENT.FIRST_NAME AS "First name" ,
STUDENT.LAST_NAME AS "Last name",
ADDRESS.ADDRESS_LINE1 AS "ADDRESS LINE1",
ADDRESS.ADDRESS_LINE2 AS "ADDRESS LINE2",
ADDRESS.ADDRESS_LINE3 AS "ADDRESS LINE3",
ADDRESS.POST_CODE AS "POST CODE",
ADDRESS.CITY AS "CITY"--,此处多了个逗号
FROM ADDRESS, COURSE, TITLE_LOOK_UP, STATUS_LOOK_UP , STUDENTWHERE  
COURSE.COURSE_TITLE = 'Information Management' and   
STATUS_LOOK_UP.STATUS_DESC = 'in progress' and  
STUDENT.COURSE_ID=COURSE.COURSE_ID and  
STUDENT.OVERALL_STATUS_ID= STATUS_LOOK_UP.STATUS_ID and  
STUDENT.TITLE_ID=TITLE_LOOK_UP.TITLE_ID and  
STUDENT.CORRESPONDENCE_ADDRESS_ID=ADDRESS.ADDRESS_ID