QueryBusinessTicketDetailVO queryBusinessTicketDetail(@Param(value = "relId") Long relId);
<select id="queryBusinessTicketDetail" parameterType="java.lang.Long"
resultType="com.cmcc.uniuser.vo.systeminterface.QueryBusinessTicketDetailVO">
SELECT
b.business_system_name as targetClientName,
c.business_system_name as sourceClientName,
a.rel_id as relId,
a.source_client_id as sourceClientId,
a.target_client_id as targetClientId
FROM ua_ticket_system_rel a
inner join ua_business_system b on a.source_client_id=b.CLIENT_ID
inner join ua_business_system c on a.target_client_id=c.CLIENT_ID
and b.DATA_STATUS!=0
where
1=1
<if test="relId!= null">
and a.rel_id = #{relId}
</if>
</select>