The
set operator OUTER UNION concatenates the results of the queries:
-
It selects all rows (both unique
and nonunique) from both tables.
-
It does not overlay columns.
The following examples
demonstrate how OUTER UNION works when used alone and with the keyword
CORR. The keyword ALL is not used with OUTER UNION because this operator's
default action is to include all rows in output.