一个oracle创建视图的sql，erro；ora-00905 missing keyword？？？？
创建视图时，sql语句报错了，有点费解，百度了一下自己没搞定，大神们谁路过，抽到时间给看看吧。谢谢
CREATE VIEW ods_worklogview AS select d.ID AS ID,b.pkey AS pid,d.pname AS pname,d.pkey AS pkey,c.pname AS issuetype,a.AUTHOR AS author,a.timeworked AS timespent,concat(format((a.timeworked / 60),0),'分钟') AS timepay,a.STARTDATE AS startdate,a.CREATED AS createdate,a.UPDATED AS lastupdatedate,b.SUMMARY AS summary,a.worklogbody AS context from (((ods_worklog a join ods_jiraissue b) join ods_issuetype c) join ods_project d) where ((a.issueid = b.ID) and (b.issuetype = c.ID) and (b.PROJECT = d.ID)) order by a.STARTDATE;
error： ora-00905 missing keyword sql 创建视图
[解决办法]
http://bbs.csdn.net/topics/290064981
[解决办法]
http://www.itpub.net/thread-386745-1-1.html
