SELECT eenameddname FROM emp e inner JOIN SELECT ename FROM emp WHERE job = SELECT job FROM emp WHERE ename = SMITH d on edeptno = ddeptno改错

SELECT e.ename,d.dname FROM emp e inner JOIN (SELECT deptno, ename FROM emp WHERE job = (SELECT job FROM emp WHERE ename = 'SMITH')) d on e.deptno = d.deptno WHERE e.ename != 'SMITH'