SELECT last_name, first_name, dept_no
FROM employees e
INNER JOIN dept_emp d on e.emp_no = d.emp_no