关于 触发器 删除

Question

主表和副表 一对多的关系。
现在的问题，主表删除一条，附表的所以纪录都删除了
代码如下
Create TRIGGER UDT_CM070_GINKO ON dbo.CM070_GINKO FOR UPDATE AS
SET NOCOUNT ON
IF UPDATE(GinkoCd)
    BEGIN
       UPDATE CM071_GINKO
       SET CM071_GINKO.GinkoCd = inserted.GinkoCd ,
           CM071_GINKO.ZenginkyoCd = inserted.GinkoCd + CM071_GINKO.ShitenCd
       FROM CM071_GINKO, deleted, inserted
       WHERE deleted.GinkoCd = CM071_GINKO.GinkoCd
       AND deleted.KaishaCd = CM071_GINKO.KaishaCd
       AND deleted.KanriCd = CM071_GINKO.KanriCd
    END
GOCreate TRIGGER DEL_CM070_GINKO ON dbo.CM070_GINKO FOR DELETE 
AS
SET NOCOUNT ON
BEGIN
DELETE CM071_GINKO FROM    CM071_GINKO ,deleted
WHERE   CM071_GINKO.GinkoCd = deleted.GinkoCd
AND  CM071_GINKO.KaishaCd = deleted.KaishaCd 
AND  CM071_GINKO.KanriCd = deleted.KanriCd 
END
GO主表示070，附表是071 ，GinkoCd KaishaCd   KanriCd 是主键

Answer 1

create tigger aaa on 表名1
as
delete 表名2 from deleted where 表名2.id=deleted.id

Answer 2

DELETE CM071_GINKO FROM    deleted --CM071_GINKO  不要?