select last_name,first_name,dept_name from employees em left join (departments depa,dept_emp dept) on
em.emp_no=dept.emp_no and dept.dept_no=depa.dept_no;