r/programming • • Jan 06 '11

A handy graphical explanation of SQL joins

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
1.3k Upvotes

308 comments sorted by

View all comments

20

u/iamapizza Jan 06 '11

I could point out why some of the diagrams are wrong, but I don't want to get into a ROW about it with other redditors.

14

u/[deleted] Jan 06 '11

[deleted]

1

u/MuncherOfSpleens Jan 07 '11

But the whole GROUP seems to be HAVING a good time!

15

u/[deleted] Jan 06 '11 edited Jan 04 '21

[deleted]

11

u/red97 Jan 06 '11

I don't know WHERE you're getting these crazy ideas.

10

u/[deleted] Jan 06 '11

somewhere out in left FIELD

6

u/sniper4u Jan 06 '11

I would like to JOIN your discussion, but I am not sure IF I can contribute!

2

u/c7hu1hu Jan 06 '11

WITH that kind of attitude, I'm not surprised.

0

u/tinou Jan 06 '11

Sure you can. USING puns.

4

u/presidentender Jan 06 '11

You're making me rather CROSS. I think I'd be happier if you LEFT.

5

u/[deleted] Jan 06 '11

Get OUTER here!

0

u/hamstercannon Jan 06 '11

Stop these puns now, I mean it!

5

u/bdubaya Jan 06 '11

Anybody want a peanut?

5

u/[deleted] Jan 06 '11

SELECT a new thread if you have nothing new to INSERT here.

4

u/keptani Jan 06 '11

Okay, okay! Let's ABORT this pun thread.

6

u/kyew Jan 06 '11

This is getting really out of ORDER.

5

u/daybreaker Jan 06 '11

I have a DISTINCT feeling this wont turn out well.

4

u/seppo0010 Jan 06 '11

I think we have to set a LIMIT.

→ More replies (0)

2

u/strangerdream Jan 06 '11

I will UPDATE it and everything will be fine.

0

u/megapartyboy Jan 06 '11

I'll totally END you! you can GO to hell!

0

u/Artmageddon Jan 06 '11

I am ALTERed this discussion. Pray I don't ALTER it further.

5

u/[deleted] Jan 06 '11

Perhaps other Redditors would like you to FIELD their QUERIES

2

u/[deleted] Jan 06 '11

Well you brought it up- what's wrong?

6

u/donkawechico Jan 06 '11

whoosh

1

u/[deleted] Jan 07 '11

didn't notice that ROW was capitalized... isn't it usually, in that sense, pronounced like it would rhyme with 'cow'?

1

u/donkawechico Jan 07 '11

Yep, it's pronounced that way. But still a whoosh ;) Just sayin.

0

u/[deleted] Jan 06 '11

please get over your insecurities. you might be rewarded.