UNION Operator (SQL) - Combining Results (UNION, UNION ALL)

In SQL, the UNION and UNION ALL operators combine results from two or more SELECT statements. However, when doing so, it requires that those results have the same columns in the same order with similar datatypes. Also, as a note, UNION will only include unique values, whereas UNION ALL will include duplicates.