Column in where clause is ambiguous - What does that mean?

php mysql join mysql-error-1052
Ben picture Ben · May 19, 2011 · Viewed 39.6k times · Source

I've come across this error in MySQL for the join clause but I'm fairly new to the JOIN argument and I'm not sure what this means. Can anyone help?

Column 'id' in where clause is ambiguous

SELECT * FROM (`venues`) 
JOIN `venues_meta` ON `venues_meta`.`venue_id` = `venues`.`id` 
WHERE `id` = '12'

Answer

Chris Morgan picture Chris Morgan · May 19, 2011

You need to fully qualify id because venues and venues_meta both have a column called id.

Related questions

Why does MySQL report a syntax error on FULL OUTER JOIN?

SELECT airline, airports.icao_code, continent, country, province, city, website FROM airlines FULL OUTER JOIN airports ON airlines.iaco_code = airports.iaco_code FULL OUTER JOIN cities ON airports.city_id = cities.city_id FULL OUTER JOIN provinces ON cities.…

Read More
How to join multiple tables using CakePHP 3?

I am using CakePHP 3.x. What I want is to be able to call $this->Categories->find() and then join Topics on Topics.cat_id = Categories.id and then join Posts on Posts.topic_id = Topics.id. I …

Read More
MySQL: Use CASE/ELSE value as join parameter

I'm trying to join the NAME and PHOTO from USERS table to the TRANSACTIONS table based on who is the payer or payee. It keeps telling me can't find the table this -- What am I doing wrong? SELECT `name`,`…

Read More