delete itr from itr,itc where itr.itr_itemid='5620' and itc.itc_itr_id=itr.itr_id delete itc from itr,itc where itr.itr_itemid='5620' and itc.itc_itr_id=itr.itr_id
delete itc where itc_itr_id=(select itr_id from itr where itr_itemid='5620') delete itr where itr_itemid='5620'--这是根据你给的资料做的测试declare @t table(id int,name varchar(20),bh int) insert into @t select 1,'zhang',12 union all select 2,'wang',13 union all select 4,'wang',14 union all select 5,'wang',15 union all select 3,'wang',18 declare @b table(id int,name varchar(20)) insert into @b select 1,'le' union all select 2,'hu'delete @b where id=(select id from @t where bh=12) delete @t where bh=12 select * from @b select * from @t
delete itc from itr,itc where itr.itr_itemid='5620' and itc.itc_itr_id=itr.itr_id
delete itr where itr_itemid='5620'--这是根据你给的资料做的测试declare @t table(id int,name varchar(20),bh int)
insert into @t
select 1,'zhang',12
union all select 2,'wang',13
union all select 4,'wang',14
union all select 5,'wang',15
union all select 3,'wang',18
declare @b table(id int,name varchar(20))
insert into @b
select 1,'le'
union all select 2,'hu'delete @b where id=(select id from @t where bh=12)
delete @t where bh=12
select * from @b
select * from @t