mabatis 关联查询用group by 提示字段重复

Question

parameterType="com.tutu.vo.ProductSelVo">
select

v.productId,v.cateId1, v.cateId2, v.cateId3, v.productName,v.originalImg,v.thumbImg, v.saleCount,v.isOnSale,v.publicId,c.cateId,c.cateName,c.publicId pi,i.itemId,i.productId,
i.smarketPrice,i.salePrice,i.stock,i.publicId,i.costPrice,b.shop_name,b.businessman_id
from
((wy_product_v1 v LEFT JOIN wy_product_item i
ON v.productId=i.productId

AND v.productName LIKE
CONCAT('%','${productSelVo.productname}','%' )

)
LEFT JOIN wy_product_cate_v1 c ON v.cateId1=c.cateId

AND c.cateName LIKE
CONCAT('%','${productSelVo.cateName}','%' )

)
LEFT JOIN t_businessman b ON v.publicId=b.businessman_id


AND b.shop_name LIKE
CONCAT('%','${productSelVo.shopName}','%' )

AND v.publicId=#{productSelVo.publicid,jdbcType=INTEGER}
AND v.status=0
GROUP BY v.productId

Answer 1

同一个sql中 每个表中的相同的字段productId 是不是要区分出来：使用：表名.字段名 来区分。