title: MS Access Inner Join On 3 Tables with the same field_name
body: <p>I'm doing an assignment for class, and I'm at my whits end. Basically, I need to write a query that uses <code>INNER JOIN</code>'s to combine all the data in 4 tables, while avoiding having titles columns with identical names (Ie <code>Table1.Master_Number</code> and <code>Table2.Master_Number</code>). The literal instructions are as follows: </p>
  
  <p><strong>Step 1:</strong>  Create a view of all the columns (only list the columns once if the columns are duplicated in the tables) in all the tables of the Lecture 5 database.  Save this query as Lecture_5_View and us this query to build the following 3 queries.  In the “FROM” clause, you MUST use an “INNER JOIN” in this query. Remember ACCESS does not support the “CREATE VIEW” command so you must create a select query. `</p>
  
  <p>Here is a screenshot of the database, that shows all the headings and column headings.
  <img src="https://i.stack.imgur.com/c960S.png" alt="Tables"></p>
  
  <p>Based on other posts like <a href="https://stackoverflow.com/questions/14995000/sql-inner-join-more-than-two-tables">this</a>, I thought that it would be pretty simple. I have this so far, but it does not want to run </p>
  
  <blockquote>
    <p>(ie Syntax error(missing operator) in query expression 'Table1.Master_Number = Table2.Master_Number INNER JOIN Table4 ON Table1.Master_Number = Table4.Master_Number)</p>
  </blockquote>
  
  <pre><code>SELECT * 
  FROM Table1
  INNER JOIN Table2 ON Table1.Master_Number = Table2.Master_Number
  INNER JOIN Table4 ON Table1.Master_Number = Table4.Master_Number
  </code></pre>
  
  <p>Where am I going wrong so far and how to I accomplish this query?</p>
  
  <p>Much thanks,
  Josh</p>