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