insert into #tmp (id_vip)
select a.id_vip from a inner join b on a.id_vip=b.id_vip
delete from a where id_vip in (select id_vip from #tmp)
delete from b where id_vip in (select id_vip from #tmp)
在执行另的二个表时如是C表,B表时,会提示数据库中已存在名为 '#tmp' 的对象。
请问怎么解决这个问题谢谢