<update id="updateRelationMsgStatus" parameterType="Map">
update msg_tbl
<set>
<if test="handle_flag != null ">handle_flag=#{handle_flag},</if>
<if test="mod_date != null ">mod_date=#{mod_date},</if>
<if test="mod_usn != null ">mod_usn=#{mod_usn},</if>
<if test="mod_uname != null ">mod_uname=#{mod_uname},</if>
</set>
WHERE
fromsn IN ( select a.fromsn from (SELECT fromsn FROM msg_tbl WHERE sn = #{sn} AND is_del != 1) a )
</update>
另起一个表,即可