一条sql执行出现错误Unknown column 'e.sal' in 'on clause'

先贴出我执行的sql，表面上看没啥错误啊

SELECT e.ename,e.sal,d.dname FROM employee e ,dept d
JOIN
(SELECT MAX(sal) AS sal FROM employee WHERE deptnu=30 ) s
ON
e.sal>s.sal
WHERE
e.deptnu=d.deptnu;

执行后报错

<e>查询：select e.ename,e.sal,d.dname from employee e ,dept d join (select max(sal) as sal from employee where deptnu=30 ) s on e.sal>s.s...

错误代码： 1054
Unknown column 'e.sal' in 'on clause'
 

百度了下是需要把联合查询的表用（）包起来才行。

改成如下：

SELECT e.ename,e.sal,d.dname FROM (employee e ,dept d)
JOIN
(SELECT MAX(sal) AS sal FROM employee WHERE deptnu=30 ) s
ON
e.sal>s.sal
WHERE
e.deptnu=d.deptnu;

执行成功