select last_name, first_name, dept_no from employees e left join dept_emp d on e.emp_no = d.emp_no where dept_no is not null;