在SQL语句中,如果使用联合检索的话,很有可能会出现ambiguous column name的错误。
原来在两张表里都有的字段名称,在选择语句中要标明是哪张表里的字段。
所以改一下就行了,在报错的字段名前面加上该字段的表名
cursor = DataTool.dbHelperTools.select("select organizationId,organizationType,organizationName,codeType,code,a.dutyUser,business, b.communityname as cname,c.gridname as gname, d.roadname as rname, a.address, a.tel from Organization a left join community b on a.communityId = b.communityId left join grid c on a.gridId = c.gridId left join road d on a.roadId = d.roadId where organizationId = '"+id+"'");