J'KYO
No pains,no gains.

oracle多表关联删除的两种方法 
第一种使用exists方法

delete   from tableA   where exits   (  
select 1  
from tableB  
Where tableA.id = tableB.id   )

  

第二种使用匿名表方式进行删除

delete   from   (  
      select 1  
      from tableA,TableB  
      where tableA.id = tableB.id   )

  

posted on 2017-09-14 15:56  J'KYO  阅读(366)  评论(0)    收藏  举报