触发器问题，在线等(40分)

CREATE TRIGGER updated ON [dbo].[ckd_detail]
FOR DELETE
AS
update md_table set ck_dh='0',is_select=0,is_ck=0 where md_table.ck_dh=deleted.ck_dh
and md_table.guige=deleted.guige

服务器: 消息 107，级别 16，状态 1，过程 updated，行 4
列前缀 'deleted' 与查询中所用的表名或别名不匹配。

update md_table set ck_dh='0',is_select=0,is_ck=0
from deleted
where md_table.ck_dh=deleted.ck_dh
and md_table.guige=deleted.guige