title: Query select an associate record value of each record
body: <p>I have to run a query(Oracle) that select all employee records with Deptment_ID=NBS
    and also brings his/her manager's name from another record, each department has many units and each has a manager(in every record there are two columns repTo and J_NBR. The manager name comes from REPTO= J_NBR )
  example:</p>
  
  <p><strong>First</strong>   &nbsp;    <strong>Last</strong> ...&nbsp;<strong>Dept_ID</strong>  &nbsp;    <strong>REPTO</strong> &nbsp;                <strong>J_NBR</strong><br>
  MIke     &nbsp;&nbsp;          SAB   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    NBS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;400&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;200
  ...</p>
  
  <p>Sarah  &nbsp;   Wood &nbsp;       NBs&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  600  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</p>
  
  <p>Chris&nbsp;   JONSON     &nbsp;   NBS  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                 600
  ...</p>
  
  <p>Here Mike's manager is SaraH Mike's REPTO= Sarah' J_NBR </p>
  
  <p>The Select query results would be(there is not a column name as manager in database):</p>
  
  <p>First  &nbsp;  Last ... &nbsp;   Deptment_ID   &nbsp;     REPTO &nbsp;  J_NBR  &nbsp;  Manager</p>
  
  <p>MIke &nbsp;&nbsp;    SAB  ...   &nbsp;    NBS &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 400  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;       Sarah</p>
  
  <p>Sarah    Wood     &nbsp;      NBs &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;             600 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;                400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      Chris 
  ..</p>
  
  <p>How would be the SQL.</p>
  
  <p>Thank,
  MK</p>