Oracle里面使用not exists代替not in的问题

[牛麦康纳]

我原来写了个程序，用了not in去处理，语句如下
select count(*) as col_0_0_ from ETKTLOG_AREA_VIEW etktlogare0_ where ((1=1 ))and(etktlogare0_.STATUS=(1))and((etktlogare0_.SERIAL_NUMBER not in(select device1_.SERIALNUMBER from DEVICE device1_ where (device1_.DEVICETYPE_ID in(select devicetype0_.ID from DEVICETYPE devicetype0_))))or((etktlogare0_.SERIAL_NUMBER is null )))
结果发现特别慢，现在想把not in换成not not exists 怎么就报错了呢？
Hibernate支持not exists吧？我看都编译过来了，就是运行的时候出错了。。。。
高手指点下。

[zyhowe]

select count(*) as col_0_0_
from ETKTLOG_AREA_VIEW a
where STATUS=1
and (
not exists(
select 1 from DEVICE b where SERIAL_NUMBER=a.SERIAL_NUMBER
and exists(select ID from DEVICETYPE devicetype0_
where id=b.DEVICETYPE_ID
)
or SERIAL_NUMBER is null
)

[牛麦康纳]

恩！谢谢楼上的，我明天再去公司实验一下啊！

[APOLLO_TS]

使用连接查询.

[money8899]

up

[sweetBug]

[Quote=引用 3 楼 APOLLO_TS 的回复:]
使用连接查询.
[/Quote]
支持