April 23, 2008 - SQL Authority with Pinal Dave

SQL SERVER – Converting Subqueries to Joins

April 23, 2008

SQL Joins, SQL Performance, SQL Scripts, SQL Server

There is always more than one way to do one thing in any programming languages. In SQL Server there is always more than one way to achieve same result set. It is quite often I see that developers write subqueries in place of joins or joins in place subqueries.