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
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.
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.
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.
Hope you enjoyed learning…
All The Best!