<sql id="tableAColumns">
a.question_id AS id,
a.remarks AS remarks,
a.del_flag AS delFlag
</sql>
<select id="get" resultType="tableAInfoResult" >
SELECT
<include refid="tableAColumns"/>
FROM tableA a
WHERE a.id = #{id}
</select>
<select id="getTableBList" parameterType="java.util.HashMap" resultType="实体路径.entity.TableB">
select
b.id AS "id",
b.remarks AS "remarks",
b.del_flag AS "delFlag"
FROM tableB b
where b.del_flag = #{delFlag}
AND b.question_id = #{questionId}
ORDER BY b.question_no ASC
</select>
resultMap里
<collection property="orderDetails" ofType="OrderDetail" column="id">
....
</collection>
sql 大概这样
select ... from order left join order_detail
on order.id=order_detail.order_id
where ...