SELECT last_name,first_name,dept_name
FROM (employees LEFT OUTER JOIN dept_emp
ON employees.emp_no=dept_emp.emp_no)
LEFT OUTER JOIN departments
ON dept_emp.dept_no=departments.dept_no;

两次左连接，注意下写法