sanjay patil
Answered On : Oct 26th, 2007
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
Login to rate this answer.
MySQL Supports following joins
Inner
Cross
Strainght
Outer
Natural
Please check following Link:
http://dev.mysql.com/doc/refman/5.0/en/join.html
Login to rate this answer.
Straight Join is similar to inner join. But a small difference.It checks left table first to optimize query.
Login to rate this answer.