This query will return all of the records in the left table (tableX) and all of the records in the right table (tableY) that do not match. I have yet to have a need for using this type of Join, but all of the others, I use quite frequently.
SELECT "select_list"
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.Key = Y.Key
WHERE X.Key IS NULL
OR Y.Key IS NULL
SELECT X.PK, X.Value,
Y.Value, Y.PK
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.PK = Y.PK
WHERE X.PK IS NULL
OR 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