像咨询一个挠头的sql语句，在线等待。谢谢了

[linxiaozhi]

有这样两个表
表A money 表 B money
20 20
22 25
28 28
28 30
30 30
31 31
31 31

我希望能对两个表做比较，结果是得到存在在表A中的而不在表B中的钱数，如22
以及钱数和个数没有完全对应的钱数，如28 30

谢谢

[pengdali]

你的表就只有一列?给出表结构。

[linxiaozhi]

我的表就只有一列而已

[samuelpan]

select * from A where not exists(select 1 from B where money=A.Money)

[linxiaozhi]

money 是货币类型的字段

[linxiaozhi]

？？？
select 1 ？？？

是什么意思呀？

[samuelpan]

Select * From A Where Money In
(Select money from
(select money,count(*) cnt from A group by money) a,
(select money,count(*) cnt from B group by money) b
Where a.money=b.money and a.cnt!=b.cnt
)

[pengdali]

select identity(int,1,1) id,* into #a from a
select identity(int,1,1) id,* into #b from b

select * from (
select (select count(*) from #a where [money]=tem.[money] and id<=tem.id) id,[money] from #a tem) a
where not exists (select 1 from (
select (select count(*) from #a where [money]=tem.[money] and id<=tem.id) id,[money] from #a tem) b
where a.id=b.id and a.[money]=b.[money])

drop table #a,#b