select  A.last_name,A.first_name,B.dept_no
from employees A
LEFT join dept_emp B
on A.emp_no  = B.emp_no