34,591
社区成员
发帖
与我相关
我的任务
分享
select * from zjolsms_ig..tb_smsdeliver c where exists
(select p_number from zjolsms_ig..tb_programinfo a,zjolsms_ig..tb_userinfo b
where a.c_id=b.u_relationid and b.u_loginname='czgd105' and b.u_level=2 and a.p_number=c.p_number)
delete from zjolsms_ig..tb_smsdeliver c where exists
(select p_number from zjolsms_ig..tb_programinfo a,zjolsms_ig..tb_userinfo b
where a.p_number=c.p_number and a.c_id=b.u_relationid and b.u_loginname='bbgd104' and b.u_level=2)
--这样就可以了
delete from zjolsms_ig..tb_smsdeliver where exists
(select p_number from zjolsms_ig..tb_programinfo a,zjolsms_ig..tb_userinfo b
where a.p_number=zjolsms_ig..tb_smsdeliver.p_number and a.c_id=b.u_relationid and b.u_loginname='bbgd104' and b.u_level=2)
delete c
from zjolsms_ig..tb_smsdeliver c
where exists
(select p_number from zjolsms_ig..tb_programinfo a,zjolsms_ig..tb_userinfo b
where a.p_number=c.p_number and a.c_id=b.u_relationid and b.u_loginname='bbgd104' and b.u_level=2)
declare @tb table(id int)
insert into @tb
select 1
delete from @tb c where c.id = 1