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