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 + '% ')