How many types of JOIN are supported by MySQL? Which are they? Explain

There are three types of joins supported in mysql as inner, right and left.
The inner join displays all the rows from both tables where match is found.
left join returns all the rows from first table even if the match is not found in second table.
While the right join returns all the rows from second table even if match is not found in first table.
Thanks

  3 Users have rated as useful.

  

Login to rate this answer.

mysql support all typ of join inner join  outerjoin(alltype ) and self join

MySQL Supports following joins

Inner
Cross
Strainght
Outer
Natural

Please check following Link:
http://dev.mysql.com/doc/refman/5.0/en/join.html

Straight Join is similar to inner join. But a small difference.It checks left table first to optimize query.