<delete
id="deleteReconnoitreRule" parameterType="Integer">
DELETE tb_reconnoitre_event_rule
FROM tb_reconnoitre_event_rule inner join tb_reconnoitre_event_config on tb_reconnoitre_event_rule.recon_event_name = tb_reconnoitre_event_config.recon_event_name
AND tb_reconnoitre_event_config.recon_event_id in
<foreach collection="list" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
</delete>
DELETE tb_reconnoitre_event_rule
FROM tb_reconnoitre_event_rule inner join tb_reconnoitre_event_config on tb_reconnoitre_event_rule.recon_event_name = tb_reconnoitre_event_config.recon_event_name
AND tb_reconnoitre_event_config.recon_event_id in
<foreach collection="list" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
</delete>