title: Access join tables
body: <p>Access 2007: We need a query to link two tables without using a unique field. Both tables have a field called "section" which is always three numbers. </p>
  
  <p>Like this example: 
           (Table A- section=101, 208, 411...) and (Table B- section=901, 304, 208...).      </p>
  
  <p>This script returns an error saying </p>
  
  <blockquote>
    <p>The multi-valued field TableB.Section is not valid in the specified JOIN clause.                                                                               </p>
  </blockquote>
  
  <pre><code>SELECT TableA.section, TableB.section...
  FROM TableA INNER JOIN TableB
  ON TableA.Section = TableB.Section;
  </code></pre>