时间戳

首页 > 解决方案 > SQL Developer doesn't recognize right outer join ORA-00905: missing keyword

sql - SQL Developer doesn't recognize right outer join ORA-00905: missing keyword

问题描述

When I try to run the below query in SQL developer, query throws ORA-00905: missing keyword exception. SQL Developer does not recognize "right" and "join" keywords.

I know this error is caused by earlier versions of oracle sql but I cannot update the version. Could you re-write the statement in order to SQL developer to understand?

SELECT R,
       S.ATT1,
       S.ATT2,
       S.ATT3,
       S.ATT4
  FROM SHELL S
 RIGHT OUTER JOIN S.ROUTE as R

标签： sqloracleouter-join

解决方案

语法错误。尝试这样的事情： 

select r.*, s.att1, s.att2, s.att3, s.att4
from shell s right outer join route r

推荐阅读