[MsSql]Sql Joins

 

1. Inner Join

SELECT [select list] FROM Table_A A INNER JOIN Table_B B ON A.Key = B.Key

 

2. Left Join

SELECT [select list] FROM Table_A A LEFT JOIN Table_B B ON A.Key = B.Key

 

3. Right Join

SELECT [select list] FROM Table_A A RIGHT JOIN Table_B B ON A.Key = B.Key

 

4. Outer Join

SELECT [select list] FROM Table_A A FULL OUTER JOIN Table_B B ON A.Key = B.Key

 

5. Left Excluding Join

SELECT [select list] FROM Table_A A LEFT JOIN Table_B B ON A.Key = B.Key
WHERE B.Key IS NULL

 

6. Right Excluding Join

SELECT [select list] FROM Table_A A RIGHT JOIN Table_B B ON A.Key = B.Key WHERE A.Key IS NULL

 

7. Outer Excluding Join

SELECT [select list] FROM Table_A A FULL OUTER JOIN Table_B B ON A.Key = B.Key WHERE A.Key IS NULL OR B.Key IS NULL