what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery
thanks
If you did not get your answer yet, then let me try to answer it in a brief...
Not Exists Check for one occurance in the Sub query and comes out and to use Not Exists you have to user subquery or co-related query.
Where in case of t Not In it chekc the condition again the set of values specified or returned by sub query....
If you can use Not eixts it is always better for performance...
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Offline 
Unsolved 
