Different types of joins in MySQL

Databases
1

Hello,
I would like to ask what is the difference between all the various kinds of joins on MySQL. I’ve read this page on the official MySQL manual but I didn’t quite get it. The most important part of this questions is when should I use each kind of join in order to use less resources?

Thanks in advance,
Kfir

2

Different kinds of joins give you different kinds of result sets. Wikipedia has lots of examples:

3

Thanks Dan,
That was a really helpful link :slight_smile:

4

perhaps this may help – http://www.sitepoint.com/forums/showthread.php?t=450051

see post #18

:wink: