0 votes
in Sql by
Define join and name different types of joins?

1 Answer

0 votes
by
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.

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
0 votes
asked Nov 8, 2021 in Sql by rajeshsharma
...