<!-- 根据关系删除附件信息表 -->
<delete id="deleteAttachByRelation" parameterClass="com.nstc.aims.model.scope.AttachRelationScope">
DELETE G_ATTACH A WHERE 1 = 1
AND EXISTS (
SELECT 1 FROM G_ATTACH_RELATION T
WHERE T.ATTACH_ID = A.ATTACH_ID
<include refid="queryAttachRelationScopeSQL" />
)
</delete>
<!-- 删除附件关联关系表 -->
<delete id="deleteAttachRelation" parameterClass="com.nstc.aims.model.scope.AttachRelationScope">
DELETE G_ATTACH_RELATION T WHERE 1 = 1
<include refid="queryAttachRelationScopeSQL" />
</delete>
其中Attach和Attach_relation是一个多对1 的关系。