Define join and name different types of joins in SQL?

Question

Define join and name different types of joins?

Answer 1

Join keyword is used to fetch data from two or more related tables. It returns rows where there is at least one match in both the tables included in the join. Read more here.

Type of joins are:

Right join

Outer join

Full join

Cross join

Self join.