**
会员member,订单order列表分页查询时的失误
**
<select id="findByCondition" parameterType="string" resultType="map">
SELECT o.id,orderDate,orderType,orderStatus,m.name ,m.phoneNumber FROM t_member m,t_order o
<where>
o.member_id = m.id
<if test="value!=null and value!='' and value.length>0">
AND (m.phoneNumber=#{value}or m.name=#{value} or m.fileNumber=#{value})
GROUP BY o.id
</if>
</where>
</select>
将 o.member_id = m.id条件放在if判断语句中造成查询出来的语句包括所有member信息!!!