三个表关联,如果实现一句SQL删除指定的一表中特定记录!! Delete c from a as a1,c as b1 where a1.Id=b.id and 条件 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DEETE C WHERE B_ID IN (SELECT ID FROM B WHERE A_ID = ID) eg:delete c from a join b on a.id = b.a_id join c on a.id = c.A_idwhere a.name = '科比' and b.id > 100 and c.id between 20 and 50 DElETE C WHERE B_ID IN (SELECT ID FROM B WHERE A_ID = (select id from a where name='xx')) DElETE C WHERE B_ID IN (SELECT ID FROM B WHERE A_ID = (select id from a where name='xx')) 为什么不使用 Cascading Referential Integrity Constraints 如何用datediff求出从今天开始往后最近一个月的数据 sqlserver2008 开发版本的企业管理器哪儿有啊?请前辈指导! 怎么样用周推算日期 索引包含问题 有用sql report server看下。邮件问题! ..在下想请问下如何将SQL数据库转换成oracle数据库 mssql数据库连接问题 DTS导入时分隔符问题 还有一个sql呢!!有点复杂啊!!请进来看看!!! 谁会把这个sql写出来 特急,如何得到新插入记录的id,试通马上结贴,在线等 急。。。在线等候。。。高人帮忙
delete c from a join b on a.id = b.a_id join c on a.id = c.A_id
where a.name = '科比' and b.id > 100 and c.id between 20 and 50