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

Actually not. It’s part of the FROM

That double indented from is hurting me

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
Create a post

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

  • Posts must be relevant to programming, programmers, or computer science.
  • No NSFW content.
  • Jokes must be in good taste. No hate speech, bigotry, etc.
  • 1 user online
  • 18 users / day
  • 117 users / week
  • 455 users / month
  • 2.2K users / 6 months
  • 1 subscriber
  • 1.69K Posts
  • 37.2K Comments
  • Modlog