select last_name,
    first_name,
    dept_no
from employees e left join
    dept_emp d on e.emp_no = d.emp_no
where dept_no is not null;