Joins in SQL SERVER

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:

  1. INNER JOIN
  2. LEFT OUTER JOIN  (or) LEFT JOIN
  3. RIGHT OUTER JOIN (or) RIGHT JOIN
  4. FULL OUTER JOIN  (or) FULL JOIN
  5. CARTESIAN PRODUCT  (or) CROSS JOIN
  6. SELF JOIN
Types of Joins in SQL Server will be discussed more in coming articles.

This entry was posted in , . Bookmark the permalink.

Leave a reply