+1-617-874-1011 (US)

  +44-117-230-1145 (UK)

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.

tableX          tableY


outer excluding join

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

sql outer excluding join homework help

Different type of SQL JOIN

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