title: Inner joins with 2 foreign keys to one primary key
body: <p>I have a table called 
  branch (branchid, branchname)
  and another table called transfer
  transfer(tranferid, sourcebranch, destinationbranch)</p>
  
  <p>both sourcebranch and destinationbranch are Fk to the branchid of of branch table.
  I need to show a query that looks like this</p>
  
  <p><strong>Tranferid   Source   Destination
     4          uk        us</strong></p>
  
  <p>but all I can get is something like this</p>
  
  <p><strong>Tranferid   Source   Destinationid
     4          uk        3</strong></p>
  
  <p>query sample</p>
  
  <p><em>select tranferid, branch.branchname, transfer.destinationbranch
  from transfer
  inner join branch on branch.branchid == transfer.sourcebranch</em></p>
  
  <p>How do I get the destination branch to show. CTE on my mind</p>