关于删除的sql问题

[mosquitoyam]

有A,B两个表,都有NO这一属性，NO中都有S1这个值
请问如何同时删除A,B二表中NO='S1’的元组
是不是用INNER JOIN?
具体请那位说一下，谢谢！

[welyngj]

是不是用INNER JOIN?
不是。

[lijinqiang]

delete A where no='s1'
delete B where no='s1'

[friendliu]

delete A where no='s1'
delete B where no='s1'
go

[welyngj]

create table a
(no int,
h1 int)
create table b
(no int,
h2 int)


insert into a values(1,2)
insert into b values(1,3)
insert into b values(2,3)
insert into a values(3,3)

create trigger tri_del_a
on a
for delete
as
delete b from deleted where deleted.no='1' and deleted.no=b.no
-------------
delete a where no=1

[wzh1215]

一次性删除不会！