如何删除表B中等b字段的信息? 有A、B两表,已知表A中a字段的值。要求利用已知表A中a字段的值,删除表B中等于表Aa字段所在的列中b字段值的数据。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update bset b=''from ajoinb on a.ID=b.aid delete b from b where b in (select a from a) delete from Bwhere exists(select * from A where a.a=b.b) --1delete b from b where b in (select a from a)--2delete b from b , a where b.b = a.a delete b from b , a where b.b = a.a 有A、B两表,已知表A中a字段的值。要求利用已知表A中a字段的值,删除表B中等于表Aa字段所在的列中b字段值的数据。 delete a from A a join B b on a.a=b.b delete b from b join a on b.a=a.a delete b from b where b in (select a from a) delete from B left join A on B.a=A.a Sql Exists最大值 ODBC连接SQL Server2000能不能够通过写脚本或者其他方式建立呢?而不是通过一步步的设置呢? 求一条SQL语句!!!! htl258 还在吗?再问个问题,行吗? 問個sql問題. SQL语句 "键列信息不足或不正确,更新影响到别的行" 请问这是什么意思 ?20分) 查询数据的解决办法? 怎样直接获取客户端IP地址? 数据应用设计疑难 SQL SERVER这个功能怎么实现? 建表???
set b=''
from
a
join
b on a.ID=b.aid
delete b from b where b in (select a from a)
where exists(select * from A where a.a=b.b)
delete b from b where b in (select a from a)--2
delete b from b , a where b.b = a.a
delete b from b join a on b.a=a.a