• I also agree with Spaghetti on this one. Your approach will work. It's just not very clear. A lack of clarity can absolutely lead to error. For example, with only three tables, how hard is this to figure out? Not that bad right. But what happens when there are six tables or sixteen being joined together. Suddenly your way gets extremely confusing and therefore error prone.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning