• SQL Server (like all DBMS) works best when dealing with sets rather than row by row operations.

    When you use the JOIN variations for this type of query, SQL Server can optimise and perform the operations effectiely in a single pass for the set rather than looking row by row.

    The query plans for the second 2 optiosn should show this.