how many types of joins are there in mysql or sql

join, left-join, mysql, right-join, sql

Solution

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

Problem

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.

Original source