三表连续连接

select t.last_name,t.first_name,h.dept_name from employees as t left join dept_emp as c on t.emp_no=c.emp_no left join departments as h on c.dept_no=h.dept_no;