title: Query to join two tables using two different columns from the first table
body: <p>I have two tables .</p>
  
  <p>Table A:</p>
  
  <pre><code>Table A ID  Table Name  owner1ID    owner2ID
  1             Work1         85         91
  2             Work2         86         92
  3             Work3         87         93
  4             Work4         88         94
  5             Work5         89         95
  6             Work6         90         96
  </code></pre>
  
  <p>Table B:</p>
  
  <pre><code>OwnerID 0WNERFIRSTNAME  0WNERlASTNAME
     85           A            M
     86           B            N
     87           C            O
     88           D            P
     90           E            Q
     91           F            R
     89           G            S
     92           H            T
     86           I            U
     94           J            V
     93           K            W
     95           L            X
  </code></pre>
  
  <p>Can you please help me out in getting a query where i need the table which contains TABLEID OWNERFIRSTNAME and OWNERSECONDNAME.</p>
  
  <p>Expected output:</p>
  
  <pre><code>TableAID 0WNER1FIRSTNAME 0WNER1LASTNAME 0WNER2FIRSTNAME 0WNER2LASTNAME
     1            A               M              F            R
  </code></pre>