MySQL查询语句如下:
SELECT `addr` FROM `table1` LEFT JOIN `table2` ON `table2`.`id`=`table1`.`id` WHERE `name` = 'James'
查询出错:Column 'name' in where clause is ambiguous
ambiguous,就是模糊不清的意思;
正确查询语句如下:
SELECT `addr` FROM `table1` LEFT JOIN `table2` ON `table2`.`id`=`table1`.`id` WHERE `table1`.`name` = 'James'
所以:在MySQL查询语句中,最好加上前缀,指定标明