select 
    e.last_name ,
    e.first_name ,
    coalesce(d.dept_no ,null) as dept_no
from employees e
left join dept_emp d
on e.emp_no = d.emp_no