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