Explain the types of joins in SQL?

In SQL, Joins is used to merge records from two or more tables in a database, based on a related column between them.

Here are the four types of the joins in SQL

• INNER JOIN: It returns records that have matching values in both tables
• LEFT JOIN: It returns all records from the left table and the matched records from the right table
• RIGHT JOIN: Right Join returns all records from the right table and the matched records from the left table
• FULL JOIN: It returns all records when there is a match in either left or right table