请教一个SQL语句问题 SELECT A.* From A LEFT JOIN B ON a.no1=b.no1 AND a.no2=b.no2 AND a.kind=b.kind WHERE B.no1 IS NULL AND b.no2 IS NULL AND b.kind IS NULL 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT * From A as a WHERE not exists (select * from B where a.no1 = B.no1and a.no2 = B.no3and a.kind = B.kind) select A.* from A inner join B on A.no1<>B.no1 and A.no2<>B.no2 and A.kind<>B.kind 以上我认为都很麻烦,其实这样就好了Select * from AMinusSelect * from B select a.* from a, b where a.no1<>b.no1 抱歉,刚才那句select * from AMinusSelect * from B只适应于oracleSQL SERVER 的可用select * from Awhere not existsselect * from B 怎么把这2个表合成1个表 100分求一个树型查询存储过程或者函数 'end' 附近有语法错误 帮忙写一下程序的显示结果! 求教一个中文识别的问题,请高手帮帮忙,急 T-SQL中大小写区分问题 数据库中有starttime(datetime)字段,和kstime(int)字段,求默认值公式starttime+kstime 误操作后怎样恢复?(急!!!) 真急啊 好几天了没能解决 希望大哥们帮帮忙! 创建教师表设置默认值出错 十万火急!在select语句中如何取出数据时按“字段1”排序以后再按“字段2”排序? 求千万级高效分页(带两个ORDERBY字段的)
WHERE not exists
(select * from B where a.no1 = B.no1
and a.no2 = B.no3
and a.kind = B.kind)
Select * from A
Minus
Select * from B
select * from A
Minus
Select * from B
只适应于oracle
SQL SERVER 的可用
select * from A
where not exists
select * from B