title: Join two tables field based on the same id?
body: <p>Need a help joining two tables based on the same id.</p>
  
  <p>Table 1:</p>
  
  <pre><code>id_1 | id_2
  </code></pre>
  
  <p>Table 2:</p>
  
  <pre><code>id | name
  </code></pre>
  
  <p>I need a query where looks for id_1 on table 2 field id and return the field name and also looks for id_2 on table 2 field id and return the field name.</p>
  
  <p>An example would be:</p>
  
  <p>Table 1:</p>
  
  <pre><code>1 | 2
  </code></pre>
  
  <p>Table 2:</p>
  
  <pre><code>1 | Joe
  2 | Michael
  </code></pre>
  
  <p>Return would be:</p>
  
  <pre><code>Joe | Michael
  </code></pre>
  
  <p>Thanks,</p>