Re: "Not in" subquery

insead of using not in use not exists.... this is alot faster....

SELECT . . .
FROM emp E
WHERE NOT EXISTS ( SELECT X'

                       FROM   dept
                       WHERE  dept_no  = E.dept_no
                       AND    dept_cat = 'A'   );