SELECT e.first_name, e.last name, d.department_id, d.department_name departments d LEFT JOIN employees e ON d.department_id = e.department
