+1-617-874-1011 (US)

  +44-117-230-1145 (UK)



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

tableX          tableY


LEFT EXCLUDING JOIN

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

left excluding join output

sql left excluding join homework help

Different type of SQL JOIN

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