太原代理记账_新网站seo优化_企业网站模板html_最近时政热点新闻

Column 'id' in where clause is ambiguous; nested exception is java.sql.SQLIntegrityConstraintViolationException: Column 'id' in where clause is ambiguous

    <sql id="selectMesMaterialCheckVo">SELECTs.id,s.serial_no,s.material_requisition_id,s.material_requisition_no,s.material_id,s.check_standard_id,s.require_quantity,s.receive_quantity,s.check_quantity,s.check_value,s.max_value,s.min_value,s.check_result,s.remark,s.check_user,s.check_date,wms_material_info.`name`,wms_material_info.model,wms_material_info.specification,wms_material_info.unit,mes_check_standard.check_item_nameFROMmes_material_check sLEFT JOIN wms_material_info ON s.material_id = wms_material_info.idLEFT JOIN mes_check_standard ON s.check_standard_id = mes_check_standard.id</sql>

这是查询参数

<select id="selectMesMaterialCheckById" parameterType="Long" resultMap="MesMaterialCheckResult"><include refid="selectMesMaterialCheckVo"/>where id = #{id}
</select>

报错代码

原因是不知道 id 是哪个

解决方法：对应查询参数的 s，或者添加前缀