MySQL UNION: Combining Results of Two or More Queries
To combine result set of two or more queries using the UNION operator, these are the basic rules that you must follow:. First, the number and the orders of columns that appear in all SELECT statements must be the same.; Second, the data types of columns must be the same or compatible.; By default, the UNION operator removes duplicate rows even if you don’t specify the DISTINCT operator ...
DA: 63 PA: 29 MOZ Rank: 30