Oracle SQL Developer "command not properly ended"语法错误

Question

我正在处理一些SQL开发人员查询，但我一直收到这个错误。我上网查了一下，但我不明白为什么我的语法会出现"SQL命令未正确结束错误"。错误显示在"FROM lgemployee as e"的行中。如果能在正确的方向上提供任何帮助，我们将不胜感激。

SELECT e.emp_num, emp_lname, emp_fname, sal_amount
FROM lgemployee as e
NATURAL JOIN lgsalary_history
WHERE sal_from = (SELECT min(sal_from))
FROM lgsalary_history as s2
WHERE (e.emp_num = s2.emp_num)
ORDER BY e.emp_num;

Answer 1

不能将as用作表的别名，只能在select语句中使用，例如：

select column as "alias"
from table a

从表声明中删除as。它应该运行良好。

Answer 2

我认为这只是错误的括号嵌套——试试

SELECT e.emp_num, emp_lname, emp_fname, sal_amount
FROM lgemployee as e
NATURAL JOIN lgsalary_history
WHERE sal_from = (SELECT min(sal_from)
FROM lgsalary_history as s2
WHERE (e.emp_num = s2.emp_num))
ORDER BY e.emp_num;