title: How to find duplicates from two tables and also to find duplicate in itself?
body: <p>I have created this statement in access 2003  </p>
  
  <pre><code>  SELECT COUNT(*)
    FROM TABLEA
    WHERE NOT EXISTS(SELECT * FROM TABLEB);
  </code></pre>
  
  <p>Does this statement helps to check if the records in table A is the same as table b? TABLEA is the new table of table b and i want to make sure that all records from table b are in table A.  </p>
  
  <p>Secondly i have this table TABLEC. How can i check if there are duplicate records, meaning all the fields values are the same, in TABLEC? </p>