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