oracle join不识别,ORA-00904 JOIN oracle上的标识符无效

最新推荐文章于 2024-05-30 14:46:52 发布

weixin_39669163

最新推荐文章于 2024-05-30 14:46:52 发布

阅读量464

点赞数

文章标签： oracle join不识别

我收到错误ORA-00904：＆＃34; S＆＃34;。＆＃34; FLIGHTLEGREF＆＃34;：此标识符无效

JOIN STAT_1 S ON D.FLIGHTLEGREF = S.FLIGHTLEGREF

这是我的查询

WITH STAT_1 AS (SELECT DEPAIRPORT AS STATION

FROM DBODSXML4OPS.XML4OPS

WHERE ACTUAL_BLOCKOFF_LC IS NOT NULL AND SERVICETYPE IN ('J','G') AND STATUS IN ('Scheduled') AND TO_CHAR(SCHEDULED_DEPDT_LC, 'yyyy-mm-dd') BETWEEN '2018-04-14' AND '2018-05-14'

ORDER BY STATION ASC)

SELECT S.STAT_1 AS STATION, COALESCE((SELECT to_number(to_char(trunc(sysdate) + avg(cast(ACTUAL_BLOCKOFF_LC as date) - cast(SCHEDULED_DEPDT_LC as date)), 'sssss'))/60

FROM DBODSXML4OPS.XML4OPS

WHERE (ACTUAL_BLOCKOFF_LC - SCHEDULED_DEPDT_LC)*24*60 > '+000000015 00:00:00.000000000'), 0) as DEPAVERAGE

FROM DBODSXML4OPS.XML4OPS D

JOIN STAT_1 S ON D.FLIGHTLEGREF = S.FLIGHTLEGREF

WHERE ACTUAL_BLOCKOFF_LC IS NOT NULL AND SERVICETYPE IN ('J','G') AND --(ACTUAL_BLOCKOFF_LC - SCHEDULED_DEPDT_LC)*24*60 > '+000000015 00:00:00.000000000' AND

STATUS IN ('Scheduled') AND TO_CHAR(SCHEDULED_DEPDT_LC, 'yyyy-mm-dd') BETWEEN '2018-04-14' AND '2018-05-14'

GROUP BY S.STAT_1

ORDER BY STATION ASC;

有人有想法吗？