title: SELECT Sql Query joins the same table twice
body: <p>I have two tables like below
  table 1:emp</p>
  
  <pre><code>Emp ID   SupervisorID
  001      005
  002      001
  003      004
  004      005
  </code></pre>
  
  <p>table 2:empdetails</p>
  
  <pre><code>ID       Name
  001      John
  002      Krish
  003      Ramesh
  004      Smith
  005      Ranga
  </code></pre>
  
  <p>I need a sql query to display ID name from table 1 in two columns Employee and its Supervisor as shows result below</p>
  
  <p>Result:</p>
  
  <pre><code>Emp     Supervisor
  John    ranga
  Krish   John
  Ramesh  Smith
  Smith   prasad
  </code></pre>