select a.last_name, a.first_name, b.dept_no
from employees a
left join dept_emp b
using(emp_no)