Types of Joins are used in SQL to combine rows from two or more tables based on a related column between them.

• Inner Join: Returns only the matching rows from both tables.

• Left Join: Returns all the row...read more

The joint as per below mentioned:

1.Inner join

2.Left join

3.Right Join

4.Outer Join

5.Cross Join

6.self Join