What are the different types of joins in SQL?

Apr 23, 2022 0 202
ProfileImage

Shahjaha Shaikh

I am a .Net developer with extensive experience with designing and developing large-scale applications. Key ...

Forums › SQL › What are the different types of joins in SQL?
loaderimage
1 Vote Up Vote Down
Shahjaha Shaikh
Staff asked 3 years ago
Add comment

Answers (1)

Add Answer
loaderimage
1 Vote Up Vote Down
Nayan Raval Marked As Accepted
Staff answered 3 years ago

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
Add comment
Add Answer

Subscribe

Select Categories