title: SQL Adding a column to a table, receiving duplicates
body: <p>I'm trying to add a column to a table, but I get duplicates which I try to avoid.
  Bad description, but I hope my example will help you to understand.</p>
  
  <p>(If someone can shortly explain how I create a nice table below it would help too :) )</p>
  
  <p>Example:</p>
  
  <ul>
  <li>Table A (id, Fund) (based on data from today)</li>
  <li>Table B (id, Fund2) (based on data from a year ago)</li>
  </ul>
  
  <p>Table A:</p>
  
  <pre><code>id   Fund
  ---------
  1    UBS
  1    UBS2
  2    MS
  </code></pre>
  
  <p>Table B:</p>
  
  <pre><code>id   Fund2
  ----------
  1    MS
  1    UBS3
  2    MS
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>SELECT A.*, B.Fund2
  FROM A 
  LEFT JOIN B ON B.id = A.id
  </code></pre>
  
  <p>Returns:</p>
  
  <pre><code>id   Fund    Fund2
  ------------------
  1    UBS     MS
  1    UBS     UBS3
  1    UBS2    MS
  1    UBS2    UBS3
  2    MS      MS
  </code></pre>
  
  <p>But what I really want to get is:</p>
  
  <pre><code>id   Fund   Fund2
  -----------------
  1    UBS    MS
  1    UBS2   UBS3
  2    MS     MS
  </code></pre>