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