Different types of joins in MySQL

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,

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

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

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

see post #18