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