In this topic, you will learn about, What is joins. Discuss the different types of Joins.

Joins: A SQL join clause combines records from two or more tables based on a common field in a relational database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining fields from two tables or more by using values common to each. ANSI-standard SQL specifies five types of JOIN: INNER, EQUI,   OUTER & CROSS joins.

Types of join:

1. Inner Join: The join that displays only the rows that have a match in both the joined tables is known as an inner join.
2. Equi-Join: Equi join is a special type of join in which we use only the equality (=) operator.
3. Outer Join: Outer join returns all the rows of both tables whether it has matched or not. We have three types of outer join:                 1. Left outer join
   2. Right outer join
   3. Full outer join
4. Cross Join: A cross join is that produces a Cartesian product of the tables.

Comment below if you have queries related to the above topic, What is joins? Discuss the different types of Joins.