OUTER EXCLUDING JOIN Homework Help

This query will return all of the records in the left table (tableX) and all of the records in the right table (tableY) that do not match. I have yet to have a need for using this type of Join, but all of the others, I use quite frequently.

SELECT "select_list"
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.Key = Y.Key
WHERE X.Key IS NULL
OR Y.Key IS NULL

EXAMPLE OF OUTER EXCLUDING JOIN :

SELECT X.PK, X.Value,
Y.Value, Y.PK
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.PK = Y.PK
WHERE X.PK IS NULL
OR Y.PK IS NULL

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