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

Question

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'

score 34 · Accepted Answer · answered May 19 '11 at 17:02

34

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

answered May 19 '11 at 17:02

Chris Morgan

4

so just to make it clear for others... it needs to become WHERE venues.id = 12 – renevdkooi Apr 22 '14 at 10:50

Scott C Wilson · Answer 2 · 2011-05-19T17:47:17.950

0

I think you want:

SELECT * FROM `venues` v, `venues_meta` m  where v.venue_id = m.id AND  m.id = '12'

(but be sure it's v.venue_id you want and not v.id)

edited May 19 '11 at 17:47

answered May 19 '11 at 17:16

Scott C Wilson

1

Your commas aren't quite correct if you're trying to alias `venues` as `v` and `venues_meta` as `m`. – Chris Morgan May 19 '11 at 17:18

score -1 · Answer 3 · answered Aug 12 '16 at 07:11

-1

Try this Code

SELECT v.*
FROM `venues` AS `v` 
INNER JOIN `venues_meta` AS `vm` ON `vm`.`venue_id` = `v`.`id` 
WHERE `v`.`id` = '12'

answered Aug 12 '16 at 07:11

E.Prokhorov

2

Please explain your code a little bit more and what your solution is – andreas Aug 12 '16 at 07:19
I created an alias for code compactness. And specify which table explicitly select `id` column – E.Prokhorov Sep 19 '16 at 05:31

3 Answers3