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
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
The types of JOIN you can use and the differences between them,
Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak:
Read More
Follow Us