title: Fatch which emails are on the same lists different tables but same column name email addressess
body: <p>I have a 11 tables            </p>
  
  <blockquote>
    <p>email1,email2,email3,email4,email5,email6,email7,email8,email9,email10,email11</p>
  </blockquote>
  
  <p>and same column name Contact_Email with different email address</p>
  
  <pre><code>&lt;?php
      $con = mysql_connect("localhost","root","");
      $db = mysql_select_db("email-db",$con);
  
      $sql = "SELECT Contact_Email FROM email1,email2,email3,email4";
      $result = mysql_query($sql);
      while($row = mysql_fetch_array($result)) {
      ?&gt;
      &lt;tr&gt;
        &lt;td&gt;&lt;? echo $row['Contact_Email']; ?&gt;&lt;/td&gt;
        &lt;td&gt;&lt;? echo '&lt;br&gt;'; ?&gt;&lt;/td&gt;
      &lt;/tr&gt;
      &lt;? } ?&gt;
  </code></pre>
  
  <p>actually I want this output   </p>
  
  <blockquote>
    <p>select all emails from all tables using join   foreach emails as email
    check if email is in table 1, if yes put yes in td   check if email is
    in table 2, if yes put yes in td   check if email is in table 3, if
    yes put yes in td</p>
  </blockquote>
  
  <p>etc</p>
  
  <p>kindly help me what can I do?</p>