SQL UNION allows you to combine two or more result sets from select statements into a single result set. The usage of using SQL UNION is as follows: SELECT statement UNION [DISTINCT | ALL] SELECT statement UNION [DISTINCT | ALL] … The column list of each individual SELECT statement must have the same data type. By default the UNION removes all duplicated rows from the result set even if you don’t explicit using DISTINCT after the UNION...