Sql OUTER JOIN Homework Help

This Join can also be referred to as a FULL OUTER JOIN or a FULL JOIN. This query will return all of the records from both tables, joining records from the left table (tableX) that match records from the right table (tableY).

SELECT "select_list"
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.Key = Y.Key

Example Of SQL Left Outer Join :

SELECT X.PK, X.Value,
Y.Value, Y.PK
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.PK = Y.PK

Different type of SQL JOIN

The types of JOIN you can use and the differences between them,

• Inner Join
• Left Join
• Right Join
• Outer Join
• Left Join Excluding Inner Join
• Outer Excluding Join
• Right Join Excluding Inner Join
• Outer Join Excluding Inner Join