How many types of join in MySQL?

There are different types of join in the MySQL: 

  • Inner Join
  • Outer Join: Left Outer Join, Right Outer Join, Full Outer Join
  • Self Join
  • Cross Join

Note: Left Outer Join is same as Left Join and Right Outer join is same as Right Join.