title: Querying the inner join of two tables with the same column name, Column 'exName' in field list is ambiguous
body: <p>I am querying the inner join of three tables using the following query. </p>
  
  <p>Two of the tables  have columns named "name1". I am getting the following error. </p>
  
  <pre><code>Column 'exName' in field list is ambiguous
  </code></pre>
  
  <p>The "name1" columns are foreign key so the information should be identical. Can anyone suggest a compact way around this?</p>
  
  <pre><code>$result = mysql_query("SELECT name1,name2,name3 FROM `table1` INNER JOIN `table2` ON table2.name1=table1.PrimaryKey INNER JOIN `table3` ON table3.name1=table1.PrimaryKey"); 
  </code></pre>