SELECT 
e.last_name ,
e.first_name ,
d.dept_no
FROM employees AS e LEFT JOIN dept_emp as  d ON e.emp_no=d.emp_no