title: Identify duplicate records in multiple databases?
body: <p>I am working on Election Department databases in India. I am asked to find the duplicate records of one database with respect to other databases of a state depending on elector name, his guardian name and age. In a state is divided in assembly constituencies and assembly constituencies into polling booth. So my state database has 68 databases as same as no of constituencies. Database name are AC_001, AC_002 so on up to AC_068 and each database contain no of tables depending on no of polling booth in a constituency named as AC001PART001,AC001PART002 so on.... in first database AC_001.
  A table roughly contain following following same fields -</p>
  
  <ul>
  <li>ccode( autoincrementation field)</li>
  <li>name of elector</li>
  <li>Relation_type(Father or husband)</li>
  <li>Relation_name(name of guardian)</li>
  <li>Assembly constituency no</li>
  <li>Polling booth no in assembly</li>
  <li>serial no( unique no given to a elector in a pooling booth)</li>
  <li>age</li>
  <li>image of elector
  <br/>Now I want a query which can generate the duplicate records of one database with respect to other depending on name, relation name and age. I also want the no of times a record repeated or duplicated. Finally I want a list which contain-</li>
  <li>Elector name</li>
  <li>Relation_Type</li>
  <li>Relation_name</li>
  <li>Assembly constituency no</li>
  <li>Pooling booth no</li>
  <li>Serial no</li>
  <li>age</li>
  <li>no of times record repeated in both databases</li>
  <li>image of elector<br/>
  I have already created a query but taking very long to return result. So please suggest the overview of query which can generate required record quickly.</li>
  </ul>