mybatis嵌套查询

mybatis嵌套查询
<resultMap id="groupResultMap" type="你要返回的类">
        <result column="updated_time" property="updateTime"/>
        <collection property="model" ofType="嵌套类"
                select="子查询id"
<!--需要多个值传参时,mybatis识别这种格式，亲自试过--!>
                column="updatedTime={updated_time},productId={product_id},supplierId={supplier_id}"> 
            <id column="id" property="id"/>
        </collection>
    </resultMap>
    <select id="子查询id"
            resultType="嵌套类">
        SELECT * FROM prc_bt_product_price_history where
        product_id = #{productId} AND supplier_id = #{supplierId} AND updated_time = #{updatedTime}
    </select>
    <select id="父查询id" resultMap="groupResultMap">
        SELECT updated_time, product_id, supplier_id , MIN(price) AS min_price FROM `prc_bt_product_price_history`
        WHERE product_id = #{condition.productId} AND supplier_id = #{condition.supplierId}
        GROUP BY updated_time
</select>