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