1653
I love it when I have to scream at a computer (lemmy.world)
submitted 2 years ago by to c/programmerhumor@lemmy.ml
167 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] 12 points 2 years ago (2 children)

You indent your JOIN? Why on earth? It lives in the same context as the SELECT.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] 9 points 2 years ago

    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
  • permalink
  • fedilink
  • source
  • parent