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...