What are different Types of Join?

Asked 20-Nov-2017
Viewed 711 times

1 Answer


0

Understanding what a JOIN is...

Combining two or more tables according to the terms mentioned in the table is possible because of the JOIN clause.

There are several types of JOIN that are mentioned:

  • Inner JOIN
  • Left (Outer) JOIN
  • Right (Outer) JOIN
  • Full (Outer) JOIN


Learning about these terms in details…

Let us seek more about them...

Inner JOIN: It selects those values whose entry are common in tables using INNER JOIN keyword
What are different Types of Join?

Left (Outer) JOIN: It returns all the values present in Table 1 with the Table 2. It displays NULL value if nothing matches Table 2.
What are different Types of Join?

Right (Outer) JOIN: It returns all the values present in Table 2 with the Table 1. It displays NULL value if nothing matches Table 1.
What are different Types of Join?

Full (Outer) JOIN: Either of the matches in Table 1 or Table 2 is been returned as records. It is considered to as the large data-set.
What are different Types of Join?

Hope you enjoyed learning…

All The Best!


Comment
Check following articles: https://www.mindstick.com/Articles/450/joins-in-sql-server https://www.mindstick.com/Articles/981/join-in-sql-server - Uttam Misra24-Nov-2017

Thank You for the answer. - Anonymous User08-Apr-2019