如果只计算一个字段还好办:
select a.*,b.* from a left join b on a.column1=b.column1 where b.column1 is null
select a.*,b.* from a left join b on a.column1=b.column1 where b.column1 is null
解决方案 »
- 问一个菜鸟问题
- |zyciis| 求一条SQL GRUOP 语句
- SQL身份验证
- 弱弱的问:两个表中对应的值求和 怎么写语句?
- 如何读取数据库日志中的记录信息?
- 求解sql多表查询:topic.csdn.net/u/20110415/19/a122136f-fe51-4082-80ac-cc5a84e432a1.html
- 求查找重复记录的MS-SQL方法
- 求助!关于优化!
- 在check约束中如何引用另外一张表中的字段?
- 高手请进(急!在线等待)
- 十万火急..SQLSERVER6.5(english)+win2000server(english)的安装问题
- 请问在存储过程里,update tablename set columnname=xxx where……这里的字段名可以为变量从外部导入么?
from a,b
where a.column1<>b.column1 and a.column2<>b.column2
select a.*,b.* from tableA a left join tableB b on a.column1=b.column1 where cast(b.column1 as varchar(20))+cast(b.column2 as varchar(20)) is null
from a
group by column1,column2
having
(select count(*) from b where b.column1 = .column1 and b.column2 = a.column2)=0有问题就说