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;