title: Rename for column names in inner Join
body: <p>I have 2 tables like this:</p>
  
  <pre><code>Table 'c'
  
  |  id  |  item_1  |   item_2  |
  -------------------------------
  |  1   |   1      |    2      |
  -------------------------------
  
  Table 'i'
  
  |  id  |  name    | 
  -------------------
  |  1   |   item   |   
  -------------------
  |  2   |  item_2  |
  -------------------
  </code></pre>
  
  <p>No i need to get from table c the result included the names of the items. so i build an inner JOIN for this.</p>
  
  <pre><code>SELECT c.*, i.name FROM c 
  
  INNER JOIN i ON 
  c.item_1 = i.id 
  OR 
  c.item_2 = i.id 
  </code></pre>
  
  <p>This works "fine". But i get something like this back:</p>
  
  <pre><code>   |  id  |  item_1  |   item_2  |  name   |
      ----------------------------------------
      |  1   |   1      |    2      | item_2 |
      ----------------------------------------
  </code></pre>
  
  <p>The problem is clear - i need to get back 2 names for the two item_ids, but only get one. So is it possible to set a new name for the column ? something like this:</p>
  
  <pre><code>SELECT c.*, i.name FROM c 
  
  INNER JOIN i ON 
  c.item_1 = i.id SET name AS name_1
  INNER JOIN i ON 
  c.item_2 = i.id SET name AS name_2
  </code></pre>
  
  <p>So the result will be like this:</p>
  
  <pre><code>   |  id  |  item_1  |   item_2  |  name_1   |  name_2 |
      ----------------------------------------------------
      |  1   |   1      |    2      | item_1 |  item_2   | 
      ----------------------------------------------------
  </code></pre>