select b.last_name,b.first_name,a.dept_no from employees b left join dept_emp a on a.emp_no=b.emp_no;