SELECT
    e.last_name,
    e.first_name,
    d.dept_no
FROM
    employees AS e
    LEFT JOIN dept_emp AS d ON d.emp_no = e.emp_no;