SELECT d.last_name,d.first_name,IFNULL(p.dept_name,"None") FROM employees dLEFT JOIN dept_emp e ON (d.emp_no = e.emp_no)LEFT JOIN departments p ON (e.dept_no = p.dept_no) 这种不是更加简单理解吗?