<resultMapid="getCompensationMapper"type="com.zhecre.jx.business.model.cases.request.SchemeAddition"><idcolumn="caseid"property="caseid"/><resultcolumn="casename"property="casename"/><resultcolumn="casetype"property="casetype"/><resultcolumn="remark"property="remark"/><collectionproperty="mechdata"ofType="com.zhecre.jx.business.model.cases.request.Mechanism"><idcolumn="caseid"property="caseid"/><resultcolumn="orgid"property="orgid"/><resultcolumn="hosname"property="hosname"/></collection><collectionproperty="catordata"ofType="com.zhecre.jx.business.model.cases.request.IndicatorData"><idcolumn="caseid"property="caseid"/><resultcolumn="indexid"property="indexid"/><resultcolumn="unit"property="unit"/><resultcolumn="coef"property="coef"/><resultcolumn="discount"property="discount"/><resultcolumn="caseid"property="caseid"/></collection></resultMap><selectid="getCompensation"resultType="com.zhecre.jx.business.model.cases.request.SchemeAddition"resultMap="getCompensationMapper">
SELECT c.casename,c.caseid,c.casetype,c.remark,
x.indexid,x.indexname,x.caseid,x.unit,x.coef,x.discount,
h.caseid,h.hosname,h.orgid
FROM PAS_CASE c,PAS_CASE_INDEX x,PAS_CASE_HOSPITAL h
WHERE c.CASEID=x.CASEID
and h.CASEID=c.CASEID
and c.CASEID=#{caseid}
</select>