Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Amin Sobati The Pitfall of "Not Equal To" Operator in Queries! RE: The Pitfall of "Not Equal To" Operator in Queries!

  • August 23, 2007 at 3:38 am

    #728831

    Can anyone explain, in detail, why the outer join solution is faster than the Subquery solution in this example?  Is the Exists method fastest of all?