题解 | #查找所有员工的last_name和first_name以及对应的dept_name#
查找所有员工的last_name和first_name以及对应的dept_name
http://www.nowcoder.com/practice/5a7975fabe1146329cee4f670c27ad55
SELECT e.last_name last_name,e.first_name first_name,a.dept_name dept_name
FROM employees e
LEFT JOIN
(SELECT d.dept_no,d.dept_name,de.emp_no
FROM dept_emp AS de, departments AS d
WHERE d.dept_no=de.dept_no) AS a
ON e.emp_no=a.emp_no