Advertisement

SQL Command not properly ended?

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;

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

Thanks

Advertisement

Answer

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

Advertisement