mybatis多表关联查询 返回类型map

<!-- 根据异型产品id和制单人筛选出制单人下过的异型产品订单号和库存数量 -->
  <select id="selectOrderNoByPIdAndSP" resultType="java.util.Map" parameterType="Map" >
    SELECT o.order_no orderNo,k.product_count productCount,c.add_date addDate
	FROM (SELECT * FROM order_info_details WHERE single_person = #{singlePerson} 
	AND product_id IN ( 
	<foreach collection="list" item="id" index="index" separator=",">
		#{id}
	</foreach>)) o left join kuwei_pro_table k on o.order_no = k.dingdan_hao 
	left join churuku_table c on o.order_no = c.dingdan_hao
  </select>