title: Joining two tables using sql with similar column names
body: <p>I have two tables:</p>
  <p>Table A.</p>
  <pre><code>| id       | name       | type     | value    |
  | -------- | ---------- |----------|----------
  | First    | row        | row      | row      |
  | Second   | row        | row      | row      |
  </code></pre>
  <p>Table B.</p>
  <pre><code>| id       | name       |condition |
  | -------- | ---------- |----------|
  | First    | row        | row      | 
  | Second   | row        | row      |
  </code></pre>
  <p>I want to select values from Table A based on the ids found in Table B. This I can do with a Join on TAbleA.id = tableB.id. But what If I want the name field from TableB and not TableA. How  do I accomplish that?</p>
  <p>The resulting tableC would be:
  Table C.</p>
  <pre><code>| id (from table A | name          | type          | value.        |
  | found in B)      | (from tableB) | (from TableA) | (from TableA) |
  | ---------------- | ------------- |---------------|---------------|
  | First            | row           | row           | row           |
  | Second           | row           | row           | row           |
  </code></pre>