Format Join Order
On our team we are very particular about the order of our joins as they are written in the query. I would like to request an option to format joins so the table you are joining on is the first item in the join. In the example below you join to tableb so the first ON clause is tableb, subsequently on the tablec join the first join is on objects from tablec.
SELECT (columns)
FROM tablea a
INNER JOIN tableb b ON
a.id = b.id
INNER JOIN tablec c ON
b.id2 = c.id
To:
SELECT (columns)
FROM tablea a
INNER JOIN tableb b ON
b.id = c.id
INNER JOIN tablec c ON
c.id = b.id2
2
votes
Christopher Mandragos
shared this idea