This Join can also be referred to as a FULL OUTER JOIN or a FULL JOIN. This query will return all of the records from both tables, joining records from the left table (tableX) that match records from the right table (tableY).
SELECT "select_list"
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.Key = Y.Key
SELECT X.PK, X.Value,
Y.Value, Y.PK
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.PK = Y.PK
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