触发器问题

[cxingh]

有两表A和B, A是B的主表, 要实现删除A表时也删除B表对应项目
表A的触发器:
Create trigger TD_A on A for delete as
delete B join deleted b on a.Id=b.Id

B表中有触发器:
Create trigger TD_B on B for delete as

If exists(select Status from A jion deleted b on a.Id=b.Id)
begin
.......
end
else
begin
......
end

问题:trigger TD_B 中的IF语句始终为False, 请问该类问题用触发器如何实现??谢谢!!!

[zjcxc]

--表A的触发器错误,应该是:
Create trigger TD_A on A
for delete
as
delete B
from B aa join deleted bb on aa.Id=bb.Id
go

[cxingh]

补充:
trigger TD_B 中IF语句为:
If exists(select Status from A jion deleted b on a.Id=b.Id where status=3)

[cxingh]

是的!!是我漏写了!!
我想请教的问题是: 在表B的触发器中要用到表A中的资料,而A表该行资料正是要删除的那行资料, 所以在B的触发器中的IF于句永远为FALSE