+1-617-874-1011 (US)

  +44-117-230-1145 (UK)

RIGHT JOIN EXCLUDING Homework Help

This query will return all of the records in the right table (tableY) that do not match any records in the left table (tableX).

tableX tableY


outer excluding join

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

EXAMPLE OF RIGHT EXCLUDING JOIN :

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



right excluding join
RIGHT JOIN EXCLUDING Homework Help

Different type of SQL JOIN

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