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).

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

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