how many types of joins are there in mysql or sql

PSR picture PSR · Mar 13, 2013 · Viewed 19.8k times · Source

I've heard there are 3 types of joins

I'm not sure of the exact names. Googling has turned up a variety of terms like :

Cross join , left join , right join , inner join , outer join, self join....

Could anyone tell me how many joins exist in MySQL all in all.

Answer

Sandy picture Sandy · Mar 13, 2013

The joins are

1. Inner Join or Equi join
2. Self Join
2. Outer Join
   outer join is again classified into
   a) Left Outer Join
   b) Right Outer Join
   c) Full Outer Join
3. Cross join