column 'XXXX' in field list is ambiguous

原因：表中包含同名字段 'xxxx'

如：select name from a,b where a.id=b.id    因为a、b2表里都有name字段

解决：字段前加上具体表名，如： select a.name from a,b where a.id=b.id

转载于:https://www.cnblogs.com/dafa/archive/2012/11/16/2772714.html