Programmer Humor

32558 readers

772 users here now

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.

founded 5 years ago

MODERATORS

cat_programmer@lemmy.ml

AgreeableLandscape@lemmy.ml

1710

I love it when I have to scream at a computer (lemmy.world)

submitted 1 year ago by tsuica@lemmy.world to c/programmerhumor@lemmy.ml

158 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] NedDasty@lemmy.world 14 points 1 year ago (2 children)

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

[–] xmunk@sh.itjust.works 9 points 1 year 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

[–] callcc@lemmy.world 6 points 1 year ago

Actually not. It's part of the FROM