delete from A where a_id in (select id from B where b_id in (select id from C where c_id = ?))请问这句SQL语句怎么优化? 我的意思万一in语句里面的内容过多会出问题的,怎么用连接表的形式去delete?

delete table from table where …… 我常见的都是 delete from table[A] where …………是 delete table[A] from table[B] where ………… VFP里的%是什么意思例：delete from 图书 where 书名=”A% 为什么不用“A* 英语翻译文件名是UserConfig.sql内容是:GO--delete old recorddelete from sysparam where p_name = 'Authercase' delete from sysparam where p_name = 'UserCFG_CRCCode' delete from sysparam where p_name = 'UserCFG_ICCard_Pwd' GO---- From Date:2007 delete a from User a where a.Tel='1001213' 第一个a 能解释下该语句的意思吗 delete from A where a_id in (select id from B where b_id in (select id from C where c_id = ?))请问这句SQL语句怎么优化? 我的意思万一in语句里面的内容过多会出问题的,怎么用连接表的形式去delete? delete from 表名 where status=1什么意思请问status=1代表什么? delete title from film where year>1970;这句哪里错了?删除资料：就会删除所有年代早于1970年（不含）的电影了.delete title from film where year DELETE FROM L_DanWei WHERE dw_id = @dw_id这几句话啥意思 特别是后面的dw_id 和 @dw_id啥意思 SQL简单语句 DELETE FROM table如何实现：删除Id从4到最后一条记录的SQL语句DELETE FROM table WHERE Id BETWEEN 4 AND ...我本来想：DELETE FROM table WHERE Id BETWEEN 4 AND (SELECT COUNT(Id) FROM table)但是不对啊. delete from与delete * fromdelete from ProdMain where ProdNum in (&delid&)我这个是从mdb数据库的应用中搞出来的,这一句不是用于sql数据库么?为什么在mdb数据库中也能用啊?mdb的不是delete * from.这样的格式么? delete from和delete * from 的区别小弟在编程时遇到了一个问题,工具是vb6.0,数据库是SQL2000,想实现删除用户表里面选中用户ID的全部信息,在语句sql=delete * from 用户表 where 用户名='& combo1.text &'时 I have delete you from my just delete me from your buddy list Access Delete 语法要求实现SQL SQL类是的语句delete t1 From table1 as t Left join table2 as t2 on t1.f1=t2.f2 Where t2.f3='abc' 下面这段代码什么意思,主要是后面条件delete from ware where ware_wareid in （select ware_wareid from ware where ware_deleted is null group by ware_wareid having count（ware_wareid） > 1） and rowid not in （select min（ delete from info join user where info.userid user.id在sql2000内执行的时候提示在关键词join附近语法错误.执行一楼代码,提示where附近语法错误 select * into b from a where 11 回答;Where does a desk come from