SQL 命令没有正确结束?

2021-12-06 00:00:00 sql oracle ora-00933 table-alias

我正在使用具有临时关系的 SQL 语句，并且收到错误 ORA-009933:SQL 命令未正确结束

I am using a SQL statement with a Temporary relation, and am getting the error ORA-009933: SQL command not properly ended

我认为该声明没有任何问题，因此非常感谢您的帮助.声明如下:

I don't see anything wrong with the statement, so any assistance is greatly appreciated. The statement is:

SELECT Temp.name,
       Temp.AvgSalary
FROM   (SELECT A.aid,
               A.aname       AS name,
               AVG(E.salary) AS AvgSalary
        FROM   Aircraft A,
               Certified C,
               Employees E) AS Temp;

谢谢

推荐答案

oracle 不支持 as 用于表别名，仅用于列别名，并且它们对于该用途是可选的 => 删除所有 as 关键字 ;)

oracle does not support as for table aliases, only for column aliases and they are optional for that use => delete all as keywords ;)

相关文章