title: Compare two tables dynamically in MS Access SQL
body: <p>Please consider we have two tables<br>
  <code>Table1</code> with (3 columns)<br>
  <code>Table2</code> with same 3 columns.</p>
  
  <p>To find the new records that are in <code>Table2</code>, but not in <code>Table1</code>, we will be using the following code.</p>
  
  <pre><code>SELECT * FROM Table2 AS T2
  WHERE (((Exists (SELECT *
          FROM
             Table1 T1
          WHERE
             T1.Field1 = T2.Field1 AND
             T1.Field2 = T2.Field2 AND
             T1.Field3 = T2.Field3))=False));
  </code></pre>
  
  <p>But, what if we don't know the number of columns in table? how can we write a generalized code or something like a forloop to compare all the columns in the table and find the new records in Table2 that are not  in table1? Please help me. I'm stuck.</p>