Types Of Joins

 

SQL Server INNER JOIN (or sometimes called simple join)
SQL Server LEFT OUTER JOIN (or sometimes called LEFT JOIN)
SQL Server RIGHT OUTER JOIN (or sometimes called RIGHT JOIN)
SQL Server FULL OUTER JOIN (or sometimes called FULL JOIN)






CROSS JOIN - Cross join is a cartesian join means cartesian product of both the tables. This join does not need any condition to join two tables. This join returns records/rows that are multiplication of record number from both the tables means each row on left table will related to each row of right table.

SELF JOIN  -- SELF JOIN is not a type of SQL Join








It is the most common type of join. SQL Server INNER JOINS return all rows from multiple tables where the join

Syntax

SELECT columns

FROM table1

INNER JOIN table2

ON table1.column = table2.column;






Comments

Popular posts from this blog

Cardigan