一个触发器的问题，急高手帮忙！

[zhaozipeng]

我写了如下的触发器，
--
--数据删除触发器()
--
CREATE TRIGGER tri_fdate_del
ON zg_f_date
FOR DELETE
AS
DELETE FROM zg_xp_jilu
where zg_f_date.f_id=zg_xp_jilu.fd_id
GO
运行时产生如下错误：
错误107：列前缀‘zg_f_date'与查询中所用的表名和别名不匹配

[zjcxc]

CREATE TRIGGER tri_fdate_del
ON zg_f_date
FOR DELETE
AS
DELETE a
FROM zg_xp_jilu a join zg_f_date b on b.f_id=a.fd_id
GO

[victorycyz]

DELETE FROM zg_xp_jilu
from zg_xp_jilu a join zg_f_date b on b..f_id=a.fd_id

[zjcxc]

--或:

CREATE TRIGGER tri_fdate_del
ON zg_f_date
FOR DELETE
AS
DELETE a
FROM zg_xp_jilu a where exists(select 1 from zg_f_date where b.f_id=a.fd_id)
GO

[victorycyz]

DELETE FROM zg_xp_jilu
from zg_xp_jilu a join zg_f_date b on b.f_id=a.fd_id

[8992026]

CREATE TRIGGER tri_fdate_del
ON zg_f_date
FOR DELETE
AS
DELETE a
FROM zg_xp_jilu a join deleted b on b.f_id=a.fd_id
GO

[8992026]

不引用deleted的删除触发器是危险的
就算没有危害，效率也是低的

[internetcsdn]

同意楼上