SELECT 
e.last_name ,
e.first_name ,
d.dept_no
FROM employees AS e INNER JOIN dept_emp as  d ON e.emp_no=d.emp_no
WHERE e.emp_no IN (
SELECT emp_no
FROM dept_emp)