hrc_public (7/25/2010)
.. glad I always try to avoid the use of subqueries in my applications.
Ummmm.... why? We just proved that the article is incorrect and that certain correctly formed subqueries can actually be faster than a classic inner join. Read the rest of the discussion above.
--Jeff Moden
Change is inevitable... Change for the better is not.