2 Replies Latest reply on Feb 10, 2013 6:28 AM by pawii

    Self Join re

    pawii
      select e.last_name,e.department_id,c.last_name
      from employees e join employees c
      on (e.department_id=c.department_id) and e.department_id=20
      /

      i want to print the names of colleagues of all employees it work fine except in the case the employee itself
      that it shows all colleague of fay plus fay colleague is fay and it follows for all employees
      so how to remove fav colleague fay