SQL Oracle LEFT JOIN和SUBQUERY错误:ORA-00905:缺少关键字 [英] SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
本文介绍了SQL Oracle LEFT JOIN和SUBQUERY错误:ORA-00905:缺少关键字的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
寻求有关此Oracle查询的帮助.它给我错误2"ORA-00905:缺少关键字".在添加LEFT JOIN语句之前,它运行良好.显然,如果没有LEFT JOIN语句,它将无法提供我们需要的信息.
Asking for your help on this Oracle query. It's giving me the error 2 "ORA-00905: missing keyword". It was working fine before I added the LEFT JOIN statement. Obviously it won't deliver the information as we need it without the LEFT JOIN statement.
请提供任何帮助以了解此查询中缺少哪个关键字
Please provide any help to know which keyword is missing in this query
非常感谢!:
数据库表: 车票 DW.TICKET_ACTLOG
DB Tables: DW.TICKETS DW.TICKET_ACTLOG
子查询表: TABLE_RESOLVERS
Subquery table: TABLE_RESOLVERS
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
推荐答案
在声明表别名时,我们不包含AS
.代替
We don't include the AS
when declaring a table alias. Instead of
) AS TABLE_RESOLVERS
写
) TABLE_RESOLVERS
这篇关于SQL Oracle LEFT JOIN和SUBQUERY错误:ORA-00905:缺少关键字的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文