mainly used to combine two tables based on a specified common field between them. If we talk in terms of Relational algebra, it is the cartesian product of two tables followed by the selection operation. Thus, we can execute the product and selection process on two tables using a single join statement. We can use either 'on' or 'using' clause in MySQL to apply predicates to the join queries.
A Join can be broadly divided into two types:
Inner Join
Outer Join
Inner Join is a join that can be used to return all the values that have matching values in both the tables. Inner Join can be depicted using the below diagram.
The inner join can be further divided into the following types:
Equi Join
Natural Join
Now let us learn about these inner joins one-by-one.
