select dd.last_name,dd.first_name,cc.dept_name from (select emp_no from employees union select emp_no from dept_emp) aa left join dept_emp bb on aa.emp_no =bb.emp_no left join departments cc on bb.dept_no=cc.dept_no left join employees dd on aa.emp_no=dd.emp_no