sql查询语句小问题..查询在结果1中查询出结果2中不存在的记录!!

[q85958341]

如何连接结果1和2,我想查询在结果1中查询出结果2中不存在的记录!!

如果用 not exists ,条件又要怎么写!

--结果1
select * from consume_main_m where stationno=-10 

--结果2
select a.cardid,a.consumeorder,a.curtime,a.stationno,a.consume,a.spare,a.computer_id,a.manage_id,a.manage_name from consume_main_m a, 
(
select * from consume_main_m	
where 
convert(varchar(10),curtime,120)>='2009-08-25'
) b
where a.cardid=b.cardid and a.consumeorder=b.consumeorder and
      a.consume=b.consume and a.spare=b.spare and a.stationno!=b.stationno

[pt1314917]

--try:

select * from consume_main_m t where stationno=-10 
and not exists
(select 1 from consume_main_m a, 
(select * from consume_main_m where convert(varchar(10),curtime,120)>='2009-08-25') b
where a.cardid=b.cardid and a.consumeorder=b.consumeorder and a.consume=b.consume
 and a.spare=b.spare and a.stationno!=b.stationno and cardid=t.cardid)

[--小F--]

;with f1 as
(
select * from consume_main_m where stationno=-10
)
f2 as
(
select a.cardid,a.consumeorder,a.curtime,a.stationno,a.consume,a.spare,a.computer_id,a.manage_id,a.manage_name from consume_main_m a, 
(
select * from consume_main_m    
where 
convert(varchar(10),curtime,120)>='2009-08-25'
) b
where a.cardid=b.cardid and a.consumeorder=b.consumeorder and
      a.consume=b.consume and a.spare=b.spare and a.stationno!=b.stationno
)
select
 *
from
 f2
where 
 not exists(select 1 from f1 where stationno=f2.stationno)

[q85958341]

数据库2000

select * from consume_main_m t where stationno=-10 
and not exists
(select 1 from consume_main_m a, 
(select * from consume_main_m where convert(varchar(10),curtime,120)>='2009-08-25') b
where a.cardid=b.cardid and a.consumeorder=b.consumeorder and a.consume=b.consume
 and a.spare=b.spare and a.stationno!=b.stationno 
and a.cardid=t.cardid)

[q85958341]

执行了N久都没出结果

[qizhengsheng]

xiao F
那个是sql2005的