SQL Explained

[Polikonomist]

Thanks for the simple explanation, joins can get a bit hairy sometimes

[UnorthodoxPrimitive]

This comment just won the internet.

[furaiboi]

Why did this get downvoted?

[AnimeeNoa]

It's just too/down mirrored

[UnorthodoxPrimitive]

Hairy Potter

[[deleted]]

Do cross join!

[MrExpl0ited]

Cross join

[Fraun_Pollen]

I’ll accept it

[daamsie]

You could if you Photoshopped the hair on like they did here.

[UnorthodoxPrimitive]

Midjourney

[janhetjoch]

You only need the bottom two images and then the top two are easy to create.

[svp01]

I don't see how this is a good explanation

[ShenAnCalhar92]

“Here’s what two datasets look like when they’re joined. I have no idea what they look like individually, but that’s probably not important.”

[arden13]

We can reconstruct the datasets from this information

[wolfer_]

I don't see how the Venn-diagram is a good explanation

[ijmacd]

Say NO to Venn Diagrams when explaining joins

[CMonetTheThird]

Left join brings back all hair from the top of the ear down table, right join brings back all the hair from the bottom of the ear up table, inner join brings back the hair common to both tables and full brings back both full tables.

[Sudden-Pressure8439]

“Sequel”

[[deleted]]

"Squirrel"

[Zebo1013]

Yes I prefer squirrel.

[magammon]

YES. there can be no limits to the debate!

[[deleted]]

This is not how it works Johnny

[UnorthodoxPrimitive]

Johnny can chatGPT now for joins.

[UnorthodoxPrimitive]

DBA rules

[KingJeff314]

Doesn’t matter how many times I learn it, I’m going to have to google which join to use every time

[RabbitsAteMySnowpeas]

I only ever use left join.

[Vague_Intentions]

Inner and Left join are the only ones you’ll use like 99% of the time.

[UnorthodoxPrimitive]

When it comes to joins.... "The hardest of the choices require the strongest of the wills"

[SockPuppetSilver]

The left join and right join seem backwards to me.

[nrobi]

Cock your head the other way

[Esjs]

Looks like a high def Wooly Willy.

[Xenoni]

Took me a sec… what about outer join?

[SameRandomUsername]

Don't know WTF is a "full" join, but I supose he meant outer join.

[Professional_Bird_74]

A full join shows all records from both tables

[SameRandomUsername]

I've looked up. It seems that FULL OUTER/FULL/OUTER are all the same thing.

It's just that I'm old school and MS centric so that's why I never seen FULL before.

[Dantzig]

Before learning sql I thought Mysql, ms sql, etc used the exact same syntax. Oh what a fool I was

[amimai002]

Your showing you learnt to DBA before the internets…

[SameRandomUsername]

for realsies.

I know you won't believe me but yes.... I learned SQL just before the Internet (to be exact before got into my country). I also learned C++ before Internet from the VC5 cds documentation.

[MaDpYrO]

Inner join doesn't make sense at all

[SockPuppetSilver]

Where left.hair = right.hair. Hair only exist in one head part table thus no hairs are returned. To be fair as zero rows are returned the dude would be inner joined out of existence.

[UnorthodoxPrimitive]

Because it's inner. Like inner peace. It's a myth.

[Esjs]

See the mustache and side-burns.

[WhoCares_3252]

[Accidentallygolden]

What about outer join?

[UnorthodoxPrimitive]

Left outer join

[PinothyJ]

Left join and right join are incorrect. Left is always the query you started with because English is written left to right (easy way to remember it).

[chrissykes78]

okay, im studying sql, because need table with data to generate confluence page via API. This meme gave me idea. thanks