两个相同结果集求差值问题 select * from 结果集1 a where not exists(select * from 结果集2 b where a.id1=b.id1 and a.id2=b.id2) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select A.*from 结果集1 A left join 结果集2 B on A.id1 = B.id1 and A.id2 = B.id2where B.id1 is null select a.id1,a.id2,a.name from a left join bon a.id1=b.id1 and a.id2=b.id2where b.id1 is null and b.id2 is null select * from awhere name not in(select name from b ) select * from 结果集1 a where not exists(select * from 结果集2 b where a.id1=b.id1 and a.id2=b.id2)UP select t1.id1,t1.id2,t1.name from t1 left join t2 on t1.id1=t2.id1 and t1.id2=t2.id2where t2.id1 is null 储存过程问题 \mssql\log\文件夹下的文件可以删除吗? sql server 2000存储过程分页 这么简单的SQL语句,为什么出错啊? 菜鸟遇到一个问题~ SQLServer2000数据库服务器复活记 数据库中表的信息存在哪个系统表中? 这样的SQL语句有错吗? 觸發器的寫法? 这样的记录该怎么select ? 菜鸟问题:怎样导入一个数据库文件? SQL Server为何提示“未找到提供者,可能未被正确安装”
from 结果集1 A left join 结果集2 B on A.id1 = B.id1 and A.id2 = B.id2
where B.id1 is null
on a.id1=b.id1 and a.id2=b.id2
where b.id1 is null and b.id2 is null
where name not in(select name from b )
from 结果集1 a
where not exists(select * from 结果集2 b where a.id1=b.id1 and a.id2=b.id2)UP
where t2.id1 is null