• You're performing either ANSI 89 style joins. Instead, you should use the ANSI 92 style

    SELECT ...

    FROM TABLEA AS a

    JOIN TABLEB AS b

    ON a.ID = b.ID

    LEFT JOIN TABLEC AS c

    ON b.NewID = c.NewID

    LEFT JOIN ...

    WHERE...

    This way you separate JOIN criteria from the filtering operations of the WHERE clause.

    "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