MySQL错误1054 : unknown column job_title

Question

任何人都可以告诉我为什么会出现此错误:

error 1054 : Unknown column 'DEPARTMENT.department_name' in 'on clause'

我真的不明白为什么

这是我的代码:

select EMPLOYEE.job_title ,EMPLOYEE.employee_id , EMPLOYEE.department_name 
from EMPLOYEE join (select EMPLOYEE.employee_id  
      from EMPLOYEE  
      group by    EMPLOYEE.employee_id 
      having count (distinct EMPLOYEE.department_name) >1)
  DEPARTMENT on  EMPLOYEE.department_name = DEPARTMENT.department_name;

Answer 1

在我看来，这是一个拼写错误:

您的查询内容为:

MPLOYEE.department_name = DEPARTMENT.department_name;

应该是:

EMPLOYEE.department_name = DEPARTMENT.department_name;