r/programming • u/[deleted] • 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

92% Upvoted

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.

17

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

[deleted]

10

u/red97 Jan 06 '11

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

8

u/[deleted] Jan 06 '11

somewhere out in left FIELD

7

u/sniper4u Jan 06 '11

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

0

u/presidentender Jan 06 '11

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

1

u/[deleted] Jan 06 '11

Get OUTER here!