title: To Compare two my sql tables with 4 constraints and save the matched results in a new table
body: <p>I want to compare 2 my sql tables with 4 constraints such as firstname,lastname,dob and address.If some records match i want to save it in the new table.</p>
  
  <p>I compared 2 tables with 1 constraint using this query </p>
  
  <pre><code>  SELECT * FROM t1 WHERE t1.dob IN (SELECT t2.dob from t2)
  </code></pre>
  
  <p>Is there any query to do this job?Any Help will be appreciated.</p>
  
  <pre><code>Table 1 
  
  First Name  Varchar
  Last  Name  Varchar
  Dob         Date
  Address     varchar
  Email       Varchar
  City        Varchar
  Country     Varchar
  
  
  Table2
  
  First Name  Varchar
  Last  Name  Varchar
  Dob         Date
  Address     varchar
  </code></pre>
  
  <p>If records matches in these tables  I want to save the following Details in Third table as </p>
  
  <pre><code>Table3
  First Name  Varchar
  Last  Name  Varchar
  Dob         Date
  Address     varchar
  Email       Varchar
  City        Varchar
  Country     Varchar
  </code></pre>