select last_name, first_name, dept_no
from dept_emp d
join employees e
on  d.emp_no=e.emp_no;