MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
query_expression_body
UNION [ALL | DISTINCT]query_block
[UNION [ALL | DISTINCT]query_expression_body
] [...]query_expression_body
: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT”
UNION
combines the result from
multiple query blocks into a single result set. This example uses
SELECT
statements:
mysql>SELECT 1, 2;
+---+---+ | 1 | 2 | +---+---+ | 1 | 2 | +---+---+ mysql>SELECT 'a', 'b';
+---+---+ | a | b | +---+---+ | a | b | +---+---+ mysql>SELECT 1, 2 UNION SELECT 'a', 'b';
+---+---+ | 1 | 2 | +---+---+ | 1 | 2 | | a | b | +---+---+