Querying the inner join of two tables with the same column name, Column 'exName' in field list is ambiguous

sql inner-join ambiguous
Ben Pearce picture Ben Pearce · Feb 23, 2013 · Viewed 70k times · Source

I am querying the inner join of three tables using the following query.

Two of the tables have columns named "name1". I am getting the following error. 

Column 'exName' in field list is ambiguous

The "name1" columns are foreign key so the information should be identical. Can anyone suggest a compact way around this?

$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");

Answer

Vincent Ramdhanie picture Vincent Ramdhanie · Feb 23, 2013

You need to qualify your column names with the table names.

 SELECT table1.name1, table2.name1, etc.

Related questions

Query error with 2 ambiguous column names in SQL

I've been working with this Query for bit now and I'm having a hard time. I'm new to SQL and I can't figure our why I'm getting the error: SELECT customer_number, first_name_initial, last_name,serve_address_1, serve_…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN in MySQL?

Read More