There are 4 types of SQL Joins :

1) Inner Join: This type of join is used to fetch the data among the tables which are common in both the tables.

2) Left Join: This returns all the rows from the table w...read more