日期:2014-05-18  浏览次数:20693 次

SQL delete
A表的C字段包含B表的D字段,就删除A表中的这条记录

------解决方案--------------------
奇怪的应用...
Delete From A
Where C in (Select A.C From A, B Where A.C Like '% ' + B.D + '% ')
------解决方案--------------------
delect a from inner join b on a.c like '% '+b.d+ '% '

------解决方案--------------------
delect a from a inner join b on a.c like '% '+b.d+ '% '
------解决方案--------------------
delete from a where c in (select b.d form a,b where a.c like '% ' + b.d + '% ')