<!-- 三表连删  删除多条-->

<!-- 类别表，用户表，中间表 -->

<delete id="DeleteThreetables" parameterType="java.util.List">

    DELETE 

ser,res,use1

FROM 

PZDF_BMS.BMS_SYS_SERVICEUSERGROUP ser 

left join

PZDF_BMS.BMS_SYS_RESERVICEUSERGROUP res 

on

ser.GROUPID = res.GROUPID

left join

PZDF_BMS.BMS_SYS_USERINFO use1

on

use1.USERID = res.USERID

WHERE 

ser.GROUPID IN

<foreach collection="list" index="index" item="item" open="(" separator="," close=")"> 

        #{item} 

    </foreach>

    AND ser.PARENTID != 0

</delete>

 <!-- 三表连删  删除一条-->

<!-- 类别表，用户表，中间表 -->

<delete id="DeleteThreetablesone" parameterType="int">

        DELETE 

ser,res,use1

FROM 

PZDF_BMS.BMS_SYS_SERVICEUSERGROUP ser 

left join

PZDF_BMS.BMS_SYS_RESERVICEUSERGROUP res 

on

ser.GROUPID = res.GROUPID

left join

PZDF_BMS.BMS_SYS_USERINFO use1

on

use1.USERID = res.USERID

WHERE 

        ser.GROUPID=#{groupId} 

<!--    ser.AND PARENTID != 0-->

    </delete>