# `UNION`

+ Combine results from multiple **`SELECT`** statements into a single result set using the **`UNION`** keyword
+ The number of columns in each **`SELECT`** statement must be the same
+ The columns in the same position in each **`SELECT`** statement must be of a compatible data type
+ The default is **`UNION DISTINCT`**, which means deduplicate
+ **`UNION ALL`** keeps duplicate rows
+ Syntax:
```
Query_1
~!@UNION [ALL | DISTINCT]@!~
Query_2
```

------------------------------------------------------------