title: Join Tables SQL Server with duplicates
body: <p>I have a table </p>
  
  <pre><code>col1
  
  1
  2
  </code></pre>
  
  <p>and other table </p>
  
  <pre><code>col1    col2    col3
  
  1          1    data value one                                    
  1          2    data value one                                    
  2          3    data value two   
  </code></pre>
  
  <p>and I want to join both tables to obtain the following result</p>
  
  <pre><code>col1  col2  col3
  
  1       1    data value one
  2       3    data value two
  </code></pre>
  
  <p>The second table have duplicates but I need to join only one (randomly). I've tried with Inner Join, Left Join, Right Join and always returns all rows. Actually I use <code>SQL Server 2008</code>.</p>