title: Merging tables in access
body: <p>I have an MS access database file with 2 tables: <code>t1</code>, <code>t2</code>. Both have primary key, suppose <code>id</code>, but <code>t1</code> has 3 columns <code>A</code>, <code>B</code> and <code>C</code>, while <code>t2</code> has columns <code>D</code>, <code>E</code> AND <code>F</code>.</p>
  
  <p>Both have the same rows, but each has different columns as stated.</p>
  
  <p>What is the easiest way to merge these two tables? Note that they are very big, and exporting to excel, CSV and such is not acceptable.</p>