title: Join two tables with not repeating values
body: <p>I have two tables 
  TableA</p>
  
  <pre><code>id    name
  1     asd
  2     afg
  3     qwe
  4     dsf
  </code></pre>
  
  <p>TableB</p>
  
  <pre><code>id    desc    uni
  1     kfgh    asad
  1     oiuy    asad
  1     wert    asad
  3     wewe    sfds
  4     lkjh    qwer
  4     poiu    qwer
  </code></pre>
  
  <p>now i want join both these tables
  to get values in column <code>uni</code> when i tried inner join </p>
  
  <pre><code>SELECT     uni FROM      tableA as A JOIN tableB as B  ON  A.id = B.id
  </code></pre>
  
  <p>it gives me all rows in TableB.as you noticed row with id 1 three times.And I can't use distinct here as this is a small part of a large query and this join statement will affect whole query.Can any one tell me what kind of join that I need to try.</p>