这个exists用法错在哪里？

[logzgh]

select employeeId,loginname,employeename
from etime.employee
where employeeid not exists(select employeeid
from etime.employeetoorg
where Orgid = iv_OrgID);

写在存储过程里面，为什么出错，出错信息为
PLS-00103:
出现符号 "EXISTS"在需要下列之一时：inlikebetween

把exists改成in后就可以了。

谢了先！

[adamdoh]

首先是语法错，应是where not exists(...)
其次，这样写效率不高，建议如下：
select employeeId,loginname,employeename
from etime.employee
minus
select a.employeeId,loginname,employeename
from etime.employee a,etime.employeetoorg b
where a.employeeid = b.employeeid
and b.Orgid = iv_OrgID;

[zjhclf]

select employeeId,loginname,employeename
from etime.employee
where not exists(select employeeid
from etime.employeetoorg
where Orgid = iv_OrgID);


试试！呵呵

[beckhambobo]

select employeeId,loginname,employeename
from employee a
where not exists(select 1
from employeetoorg
where Orgid = iv_OrgID
and employeeid=a.employeeid);