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
Post a Comment