删除的问题，很简单，帮忙了

Question

create trigger xx on table1
for delete
as 
begin
   delete table2 from deleted where table2.number=deleted.number
end
go

Answer 1

create trigger tr_ on table
for delete
as
deleted from table2  where 身份证号 in(select 身份证号 from deleted)

Answer 2

create trigger trigger_name 
on table1
for delete
as 
begin
   delete table2 from deleted 
where table2.身份证号 =deleted.身份证号 
end
go

Answer 3

create trigger xx on table1
for delete
as 
delete table2 from deleted where table2.身份证号=deleted.身份证号