Joins Archives - Born SQL

It’s a quiet month as we look forward to 2016, so I’m asking a series of survey questions for the next few posts. My first one is about the order of join predicates. When joining two or more tables in T-SQL, which do you prefer?

SELECT *
FROM TableA a
INNER JOIN TableB b
   ON <strong>a</strong>.Col1 = <strong>b</strong>.Col1

SELECT *

FROM TableA a

INNER JOIN TableB b

ON a.Col1 = b.Col1

SELECT *
FROM TableA a
INNER JOIN TableB b
   ON <strong>b</strong>.Col1 = <strong>a</strong>.Col1

SELECT *

FROM TableA a

INNER JOIN TableB b

ON b.Col1 = a.Col1

The SQL Server Query Optimizer doesn’t care, so
-> Continue reading Survey: Join Predicate Order