What is join ? How many different types of joins can you create in MySQL ?

A join is a query that combines rows from two or more tables based on a condition.

In MySQL, we can create two main types of joins: unrestricted joins, which include the Cross Join or Cartesian Product, and restricted joins, which include Equi Join, Non-Equi Join, Natural Join, Left Join, and Right Join.