title: Inner join Without duplicates, is it possible?
body: <p>Given these two tables
  Table A1 has two rows with the same value 'a'</p>
  
  <pre>
  A1
  a
  a
  </pre>
  
  <p>Table A2 has two rows with primary key value A,B and they are associated with 'a'</p>
  
  <pre>
  A2
  PK col2
  A   a
  B   a
  </pre>
  
  <p>What I want is a join of A1 and A2 with this result</p>
  
  <pre>
  a A
  a B
  </pre>
  
  <p>Obviously inner join doesn't work here. Is there a way to do this in SQL Server 2008?</p>