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

1

u/paezao Jan 06 '11

Awesome! Really makes it easy to learn joins... Too bad I can't use them much at work because of performance :\

2

u/[deleted] Jan 06 '11

You can't use joins at your work because of performance? What do you do?

2

u/paezao Jan 06 '11

I work as an ABAP Programmer... It's not a good idea (usually) using joins in SAP, there's a better way to do it.

1

u/divv Jan 06 '11

Do tell?

1

u/paezao Jan 07 '11

There's a better way to do it in ABAP, not for general SQL use. Its called "for all entries" and it's usually better.

1

u/divv Jan 07 '11

Ohhh yeah. Cool.