sanjay patil

• 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

sampra

 Profile Answers by sampra 

• Mar 10th, 2008

 

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

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

MySQL Supports following joins

Inner
Cross
Strainght
Outer
Natural

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

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

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

shriram

• Jun 4th, 2015

 

Different types of joint are
Outer Join
Inner Join
Cross Join
Self Join
Union Join

Bhagya Killi

 Profile Answers by Bhagya Killi 

• Jun 14th, 2016

 

Inner Join
Left Join
Right Join
Full Join

Onkar Nath Maurya

• May 29th, 2017

 

All type join supports in mysql
Inner join
Full join
Left join
Right join
Union join