You are viewing a single thread.
View all comments View context
14 points

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

permalink
report
parent
reply
6 points

Actually not. It’s part of the FROM

permalink
report
parent
reply
2 points

That double indented from is hurting me

permalink
report
parent
reply
8 points

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
report
parent
reply

Programmer Humor

!programmerhumor@lemmy.ml

Create 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.

Community stats

  • 4.3K

    Monthly active users

  • 1.5K

    Posts

  • 35K

    Comments