1687

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

170 comments fedilink hide all child comments

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

[-] NedDasty@lemmy.world 12 points 1 year ago

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

[-] Stumblinbear@pawb.social 2 points 1 year ago

That double indented from is hurting me

this post was submitted on 19 Oct 2023

1687 points (98.8% liked)

Programmer Humor

32426 readers

1035 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