select 
    t1.last_name,
    t1.first_name,
    t2.dept_no
from employees t1 
  inner join dept_emp t2 on t1.emp_no = t2.emp_no