title: multiple select statements on the same table?
body: <p>I have trouble to make this multiple select statement.</p>
  
  <p>this is example if i select *. in the reportsto column it's ID for another Employee.
  and i want to display firstname and lastname of this emplyee in this column</p>
  
  <pre><code>empID   FName  LName ReportsTo
  1         te    xxxx     6
  6         aaa   asfa     1
  5         zzz   xxxx     6
  4         ttt   asfa     1
  
  
  
  
  this how i want to display it on my gridview
  empID   FName  LName ReportsTo
  1         te    xxxx     aaa asfa      
  6         aaa   asfa     te xxxx
  5         zzz   xxxx     te xxxx
  4         ttt   asfa     aaa asfa
  </code></pre>
  
  <p>Thanks in advace </p>