SELECT
    E.last_name,
    E.first_name,
    D.dept_no
FROM
    employees E
    LEFT JOIN dept_emp D ON E.emp_no = D.emp_no
WHERE
    D.dept_no IS NOT NULL;