使用 FULL OUTER JOIN 报错信息为“SQL 命令未正确结束”
SQL语句如下:
select dttest as DTIME,(1 - intsucceed/inttimes)*100 as LRT,ifoutval/(1000*1000) as OUTFLUX from testrecord FULL OUTER JOIN snmp_val1 ON (testrecord.dttest=snmp_val1.dt)
报错信息为:
SQLWKS> select (1 - intsucceed/inttimes)*100 as LRT,ifoutval/(1000*1000) as OUTFLUX from testrecord FULL OUTER JOIN snmp_val1 ON testrecord.dttest=snmp_val1.dt
2>
select (1 - intsucceed/inttimes)*100 as LRT,ifoutval/(1000*1000) as OUTFLUX from testrecord FULL OUTER JOIN snmp_val1 ON testrecord.dttest=snmp_val1.dt
*
ORA-00933: SQL 命令未正确结束
请问错误在那里?