where子句中的列不明确-这是什么意思? [英] Column in where clause is ambiguous - What does that mean?

问题描述

我在MySQL的join子句中遇到了这个错误，但是我对JOIN参数还很陌生，我不确定这意味着什么.有人可以帮忙吗?

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?

where子句中的"id"列不明确

Column 'id' in where clause is ambiguous

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

推荐答案

您需要完全限定id，因为venues和venues_meta都有一个名为id的列.

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

这篇关于where子句中的列不明确-这是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！