select last_name, first_name, dept_no
from employees a left join dept_emp b on a.emp_no=b.emp_no