LEFT EXCLUDING JOIN Homework Help

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

SELECT "select_list"
FROM TableX X
LEFT JOIN TableY Y
ON X.Key = Y.Key
WHERE Y.Key IS NUL

Example Of SQL Left Excluding Join :

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

OUTPUT

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