+1-617-874-1011 (US)

  +44-117-230-1145 (UK)

Sql OUTER JOIN Homework Help

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

tableX         tableY


outer join

SELECT "select_list"
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.Key = Y.Key

Example Of SQL Left Outer Join :

SELECT X.PK, X.Value,
Y.Value, Y.PK
FROM TableX X
FULL OUTER JOIN TableY Y
ON X.PK = Y.PK

Sql Outer Join Homework Help

Different type of SQL JOIN

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