# UNION
__*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:
```12
query_1
UNION [ALL | DISTINCT]
query_2
```

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