FULL OUTER JOIN
FULL OUTER JOIN merges two streams of incoming rows and produces one stream containing the SQL FULL OUTER JOIN of both streams.
Syntax
Select *
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name;
Remarks
|
•
|
The FULL OUTER JOIN combines the results of both left and right outer joins. |
|
•
|
When no matching rows exist for rows on the left side of the JOIN key word, NULL values are returned from the result set on the right. |
|
•
|
When no matching rows exist for rows on the right side of the JOIN key word, NULL values are returned from the result set on the left. |
|
•
|
The query engine hashes the lesser side and streams the greater side over it. |
Example
SELECT *
FROM /shared/examples/ds_orders/orderdetails orderdetails
FULL OUTER JOIN /shared/examples/ds_orders/products products
ON orderdetails.ProductID = products.ProductID;