0 votes
in Sql by
What are the different types of joins in SQL?

1 Answer

0 votes
by

Joins are used to merge two tables or retrieve data from tables. It depends on the relationship between tables. According to the ANSI standard, the following are the different types of joins used in SQL:

  • INNER JOIN
  • SELF JOIN
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • CROSS JOIN

Related questions

0 votes
asked Apr 22, 2020 in DBMS by Hodge
0 votes
asked Nov 7, 2021 in Sql by rajeshsharma
...