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