SQL命令未正确结束? [英] SQL Command not properly ended?

查看:129
本文介绍了SQL命令未正确结束?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在使用具有临时关系的SQL语句,并收到错误ORA-009933: 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; 

谢谢

推荐答案

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 ;)

这篇关于SQL命令未正确结束?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆