Joins play a vital role in retrieving data from 2 or more tables in SQL SERVER.
JOIN is the keyword which is used to link 2 or more table and get the required data based on the matching criteria in the joined tables.
There are 6 types of joins in SQL Server:
- INNER JOIN
- LEFT OUTER JOIN (or) LEFT JOIN
- RIGHT OUTER JOIN (or) RIGHT JOIN
- FULL OUTER JOIN (or) FULL JOIN
- CARTESIAN PRODUCT (or) CROSS JOIN
- SELF JOIN
Types of Joins in SQL Server will be discussed more in coming articles.
