title: Why i am getting this output
body: <p>I am using oracle 11g command line and using basic query on default EMPLOYEES table came with 11g :-</p>
  
  <pre><code> SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.FIRST_NAME, EMPLOYEES.LAST_NAME, 
   EMPLOYEES.MANAGER_ID
   FROM
   EMPLOYEES
   WHERE
   EMPLOYEES.MANAGER_ID IN
   (SELECT EMPLOYEES.EMPLOYEE_ID 
    FROM EMPLOYEES
    WHERE EMPLOYEES.MANAGER_ID =
    (SELECT EMPLOYEES.MANAGER_ID 
     FROM EMPLOYEES 
      WHERE 
      EMPLOYEES.FIRST_NAME ='Nancy'));
  </code></pre>
  
  <p>==========================================</p>
  
  <h1>OUTPUT</h1>
  
  <pre><code>EMPLOYEE_ID FIRST_NAME           LAST_NAME                 MANAGER_ID
  ----------- -------------------- ------------------------- ----------
          109 Daniel               Faviet                           108
          110 John                 Chen                             108
          111 Ismael               Sciarra                          108
          112 Jose Manuel          Urman                            108
          113 Luis                 Popp                             108
          206 William              Gietz                            205
  </code></pre>
  
  <p>6 rows selected.</p>
  
  <p>I am unable to understand why the last row with id=206 is there,whereas the 108 is EMPLOYEE_ID of Nancy which is not related to 206 id.</p>