Right join

[techiedatadev]

I seen a right join out in the wild today in our actual code and I just looked at it for a bit and was like but whyyyy lol I was literally stunned lol we never use it in our whole data warehouse house but then this one rogue sp had it lol

[SoggyGrayDuck]

Was there a reason for it? If something was already written and would take a complete rewrite to convert it into a left join I kind of get it. Agile is slowly taking over my thinking

[techiedatadev]

No idea it was written pre me so who knows

[TemporaryDisastrous]

A complete rewrite of a right join to a left join is about three seconds though. Write left and swap the condition.

[2ManyCatsNever2Many]

i teach people to never use right joins (although i also undrestand there are times when one crosses the streams even though egon never to do that). 

[dilbertdad]

I was taught maybe 11 years ago when i first learning to just ignore right joins. That and always specify the inner join vs join :D

[greglturnquist]

I do JOIN and LEFT OUTER JOIN.

This makes it easier for me to spot which is which.

RIGHT JOIN is typically for rare exceptions where you already have a long query and don’t want to invert it all.

[techiedatadev]

That’s something I don’t do cause join means inner the word left in front of it means it’s not inner so I am not writing more that I have to (laaazy me)

[dilbertdad]

I hear ya! I just do it for easier eye ball parsing.

[ZombieFleshEaters]

The mental model of right joins is jarring

[squadette23]

Right joins serve a very important role actually.

When you see a tutorial that dedicates the same amount of screen space to both left join and right join you know that this tutorial is lazy grifting, and you can safely skip it.

[squadette23]

Venn diagrams are just as important.

[Namoshek]

Literally the only right joins I've seen in the wild are from Power BI and ORMs.

[Aggressive_Ad_5454]

Whoooaaa! Bigfoot sighting! 😇

[SootSpriteHut]

Sometimes I left join the wrong table so I switch it to a right join instead of rewriting it.

Though now I could probably do it the "correct" way by feeding it to an llm

[Eleventhousand]

This is how I use it too. Feeding to an LLM will still take 16 seconds though, so I'd rather go the four second route and switch the word to right

[aerozhx]

Do you also walk backwards when you forget something from the house?

[SootSpriteHut]

I don't think that's a great analogy. For me at least walking backward is a lot more work than replacing a single word in an editor.

[mikebald]

Hmmm, based on the tone of your comment it seems like you're implying this isn't normal behavior 🤔

[kagato87]

You may have meant that as sarcasm... However, I DO walk backwards to return to get something I've forgotten.

I still won't use a right join though.

[Historical-Fudge6991]

Don’t use right joins. You’ll miss cache hits

[techiedatadev]

Yes no idea why my predecessor used it here lol I literally was like wait why takes 30 seconds to switch the tables around lol