The UNION / UNION ALL operators are used to combine the result-sets of two or more SELECT statements.
The difference between two of them is that he UNION operator selects only distinct values by default. To allow duplicate values, UNION ALL should be used.