select last_name,first_name,dept_no
from employees right join dept_emp using(emp_no)