title: Using INNER JOIN to link mutliple columns from two tables
body: <p>I'm using XAMPP and I have two tables, customers and table2.</p>
  
  <p>Customers has the following columns: <code>Customer_Name</code>, <code>Address</code>, <code>City</code>, <code>State</code>
  table2 has the following columns: <code>City</code>, <code>State</code>, <code>Zip_Code</code></p>
  
  <p>The tables were created to achieve 3rd normalization.  I don't have a problem using a single INSERT statement to load data to each table, but I'm unable to use INNER JOIN to combine the tables and run my query.  Here's what I have so far:</p>
  
  <pre><code>SELECT Customer_Name, Address, City, State FROM customers 
  INNER JOIN table2 ON customers.City=table2.City
  INNER JOIN table2 ON customers.State=table2.State;
  </code></pre>
  
  <p>The error being returned is </p>
  
  <blockquote>
    <p>#1066 - Not unique table/alias: 'table2' </p>
  </blockquote>
  
  <p>Any help would be appreciated.</p>