建立视图出错，帮忙看下

Question

SELECT是SQL里面拷出来的语句，想在ORACLE里面建一样的视图，但执行后，报　SQL命令未正确结束　错误，
怎么改啊create or replace VIEW VIEW_COURSE
AS
  
SELECT     COURSE_COND.TrainPlan_ID, COURSE_COND.Subject_NO, COURSE_COND.TrainPlan_Date, COURSE_COND.Mark, 
                      COURSE_COND.COND, COURSE_COND.COURSE_ID, SUBJECT_DICT.SUBJECT_NAME, TEACHERS_INDEX.NAME AS TeacherName, 
                      COURSE_COND.START_TIME, COURSE_COND.END_TIME, COURSE_COND.TEARCHER_ID, COURSE_COND.IsGrant, 
                      HOSPITAL_CONFIG.TreeKey, HOSPITAL_CONFIG.ParentID, HOSPITAL_CONFIG.UNIT_CODE, HOSPITAL_CONFIG.HOSPITAL, 
                      COURSE_COND.AttestationType, COURSE_COND.IsSetPerson, COURSE_COND.UNIT, TRAIN_PLAN.IsLock, 
                      COURSE_COND.Content, COURSE_COND.SERIAL_NO, TRAIN_PLAN.HOSPITAL_NO
FROM         TRAIN_PLAN INNER JOIN
                      COURSE_COND INNER JOIN
                      SUBJECT_DICT ON COURSE_COND.Subject_NO = SUBJECT_DICT.SUBJECT_CODE INNER JOIN
                      TEACHERS_INDEX ON COURSE_COND.TEARCHER_ID = TEACHERS_INDEX.TEACHER_ID ON 
                      TRAIN_PLAN.PLAN_ID = COURSE_COND.TrainPlan_ID INNER JOIN
                      HOSPITAL_CONFIG ON TRAIN_PLAN.HOSPITAL_NO = HOSPITAL_CONFIG.HOSPITAL_NO

Answer 1

这样执行一下create or replace VIEW VIEW_COURSE 
AS 
  
SELECT    
COURSE_COND.TrainPlan_ID, COURSE_COND.Subject_NO, COURSE_COND.TrainPlan_Date, COURSE_COND.Mark, 
COURSE_COND.COND, COURSE_COND.COURSE_ID, SUBJECT_DICT.SUBJECT_NAME, TEACHERS_INDEX.NAME AS TeacherName, 
COURSE_COND.START_TIME, COURSE_COND.END_TIME, COURSE_COND.TEARCHER_ID, COURSE_COND.IsGrant, 
HOSPITAL_CONFIG.TreeKey, HOSPITAL_CONFIG.ParentID, HOSPITAL_CONFIG.UNIT_CODE, HOSPITAL_CONFIG.HOSPITAL, 
COURSE_COND.AttestationType, COURSE_COND.IsSetPerson, COURSE_COND.UNIT, TRAIN_PLAN.IsLock, 
COURSE_COND.Content, COURSE_COND.SERIAL_NO, TRAIN_PLAN.HOSPITAL_NO 
FROM        
TRAIN_PLAN 
INNER JOIN COURSE_COND ON TRAIN_PLAN.PLAN_ID = COURSE_COND.TrainPlan_ID 
INNER JOIN SUBJECT_DICT ON COURSE_COND.Subject_NO = SUBJECT_DICT.SUBJECT_CODE
INNER JOIN TEACHERS_INDEX ON COURSE_COND.TEARCHER_ID = TEACHERS_INDEX.TEACHER_ID 
INNER JOIN HOSPITAL_CONFIG ON TRAIN_PLAN.HOSPITAL_NO = HOSPITAL_CONFIG.HOSPITAL_NO

Answer 2

格式化以后
 INNER JOIN COURSE_COND --条件？
 INNER JOIN SUBJECT_DICT ON COURSE_COND.Subject_NO =
                            SUBJECT_DICT.SUBJECT_CODE
 INNER JOIN TEACHERS_INDEX ON COURSE_COND.TEARCHER_ID =
                              TEACHERS_INDEX.TEACHER_ID ON
                              TRAIN_PLAN.PLAN_ID = COURSE_COND.TrainPlan_ID-- 写错地方了
 INNER JOIN HOSPITAL_CONFIG ON TRAIN_PLAN.HOSPITAL_NO =
                               HOSPITAL_CONFIG.HOSPITAL_NO