MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4
query_expression_bodyUNION [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 | +---+---+