1、使用场景
今天用到多数据拼接字段的方法,不会用sql做,特此记录。
2、sql语句
<select id="queryCaseInfoDetails" resultType="com.iflytek.sf.zlfy.model.vo.SettlementVo">
select c.case_order_no as caseOrderNo,
c.case_type as caseType,
c.receive_file_time as receiveFileTime,
c.deadline_time as closeTime,
c.case_status as caseStatus,
( SELECT GROUP_CONCAT( a.applicant_name ORDER BY a.sort ) AS applicantName FROM t_applicant_info a WHERE
a.case_order_no = c.case_order_no ) AS applicantName,
( SELECT GROUP_CONCAT( r.respondent_name ORDER BY r.sort ) AS respondentNames FROM t_respondent_info r WHERE
r.case_order_no = c.case_order_no ) AS respondentName,
0 as seekReviewDocument,
0 as isPublishOpinionDoc,
0 as isPublishProposalDoc,
ad.apply_type as applyType,
ad.behavior_type as behaviorType,
ad.administrative_type as administrativeType
from t_case_info c
left join t_case_apply_detail ad on c.case_order_no = ad.case_order_no
where c.case_order_no = #{caseOrderNo,jdbcType=VARCHAR}
group by c.case_order_no
</select>