这个exists用法错在哪里？

Question

首先是语法错，应是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;

Answer 1

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

Answer 2

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