I’ve seen both approaches and I think they’re both quite reasonable. An indented join is my preference since it makes sub queries more logically indented… but our coding standards allow either approach. We’ve even got a few people that like
FROM foo
JOIN bar ON foo.id = bar.fooid
JOIN baz ON bar.id = baz.barid
You indent your JOIN? Why on earth? It lives in the same context as the SELECT.
I’ve seen both approaches and I think they’re both quite reasonable. An indented join is my preference since it makes sub queries more logically indented… but our coding standards allow either approach. We’ve even got a few people that like
FROM foo JOIN bar ON foo.id = bar.fooid JOIN baz ON bar.id = baz.baridActually not. It’s part of the FROM
That double indented from is hurting me