SQL命令未正确结束? [英] SQL Command not properly ended?
本文介绍了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屋!
查看全文