title: Compare two tables and find matches in ms-access 2007
body: <p>I am trying to compare two tables in ms access 2007 to find matches from the tables which I know to have one field in common. When I try to run the following query</p>
  
  <pre><code>SELECT
  FROM FirstTrial INNER JOIN ConsolidatedDatabase 
  ON FirstTrial.ModelNumbr = ConsolidatedDatabase.ModelNumbr;
  </code></pre>
  
  <p>I get an error 'Query must have at least one destination field'</p>
  
  <p>What do I need to change in order to make the query work?</p>