有没有一条语句删除（符合条件的）多表的中记录（如果是用触发器该怎样写呢）

[liutingrun]

有没有一条语句删除（符合条件的）多表的中记录（如果是用触发器该怎样写呢）

[晓风残月0110]

declare @tb table(id int,t1id int,name varchar(20),work varchar(20))
insert into @tb select 1,1,'张三','教师'
insert into @tb select 2,1,'李四','学生'
insert into @tb select 3,2,'王五','教师'
insert into @tb select 4,3,'赵六',''
insert into @tb select 5,1,'刘七','教师'
declare @ta table(id int,school varchar(20))
insert into @ta select 1,'aa学校'
insert into @ta select 2,'bb学校'
insert into @ta select 3,'cc学校'
select * from @ta
delete from @ta 
where id in (select t1id from @tb)
select * from @ta


--
--delete from @ta 
--where id in (select t1id from @tb left join 表 .... where id in ....)

[starsong]

CREATE TRIGGER [TRIGGERFORFORt_test] ON [dbo].[test]
FOR DELETE
AS
delete from table where a.xx= deleted.xx
delete from table where b.xx= deleted.xx