oracle中报00905,SQL Oracle左联接和子查询错误:ORA-00905:缺少关键字

请求您对此Oracle查询的帮助。它给了我错误2“ORA-00905:缺少关键字”。在添加左联接语句之前,它工作得很好。显然,如果没有左联接语句,它将无法按需要传递信息。

请提供任何帮助以了解此查询中缺少哪个关键字

谢谢!:

数据库表:

门票

dw.ticket活动日志

子查询表:

表格解析器

SELECT

TO_CHAR(DW.TICKETS.RESOLVED_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS') AS RESOLVED_DATE,

DW.TICKETS.SUBJECT, DW.TICKETS.OWNER_CORE_ID,

DW.TICKETS.TICKET_NUMBER,

TABLE_RESOLVERS.SUBMITTER AS RESOLVER_CORE_ID

FROM DW.TICKETS

LEFT JOIN

(SELECT

TICKET_NUMBER,

SUBMITTER

FROM DW.TICKET_ACTLOG

WHERE

TYPE = 'Final Resolution' AND

(SUBMITTER = 'B02666' OR

SUBMITTER = 'R66604')

ORDER BY CREATE_TIMESTAMP DESC

) AS TABLE_RESOLVERS

ON DW.TICKETS.TICKET_NUMBER = TABLE_RESOLVERS.TICKET_NUMBER

WHERE

DW.TICKETS.RESOLVED_TIMESTAMP >= to_date('05-03-2010','dd-mm-yyyy') AND

DW.TICKETS.RESOLVED_TIMESTAMP < to_date('8-03-2010','dd-mm-yyyy') AND

DW.TICKETS.TICKET_NUMBER LIKE 'TCK%' AND

DW.TICKETS.TICKET_NUMBER IN

(SELECT TICKET_NUMBER

FROM DW.TICKET_ACTLOG

WHERE

(SUBMITTER = 'B02666' OR

SUBMITTER = 'R66604')

)

ORDER BY DW.TICKETS.CREATE_TIMESTAMP ASC