请教这个触发器错在哪？

[gao_gao]

我的触发器，在单独删除一条HZB记录时运行正常，而删除多条HZB记录时，出现错误：

子查询返回的值多于一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的

我的触发器是这样的，
CREATE TRIGGER [删除对应明细] ON [dbo].[总表]
FOR DELETE
AS
declare @del_id varchar(20)
select @del_id=id from deleted
delete from 明细表 where id=@del_id

请有经验的大哥指点为谢！

[jetdw]

你这样试试
CREATE TRIGGER [删除对应明细] ON [dbo].[总表]
FOR DELETE
AS
declare @del_id varchar(20)
select @del_id in(select id from deleted)
delete from 明细表 where id=@del_id

[LouisXIV]

--啰里啰唆的，写成下面这样即可

CREATE TRIGGER [删除对应明细] ON [dbo].[总表]
FOR DELETE
AS
delete from 明细表 where id in (select id from deleted)