title: SQL Server Compare rows of one table with all rows of other table
body: <p>I have 2 tables which contains firstname, surname,dob.
  First table has datatype as varchar for all columns and second table is varchar(50),varchar(50),datetime datatype.</p>
  
  <pre><code>Ex:
  1st table 
  fname surname dob
  a       b      04/12/1948
  a       b      05/08/1984
  
   2nd table
  fname surname dob
  a       b      05/08/1984
  a       b      04/12/1948
  </code></pre>
  
  <p>when i do Intersect is not matching the decors (possibly b'ze of datatype)
  and except give me result.</p>
  
  <p>Is there any way to select all record from table 1 with matching records of table 2.</p>
  
  <p>Any help much apprecciated</p>