union: combine two table without duplication
union all: with duplication
Anonymous
4 Mar 2017
Union statement combines result of two or more SELECT statement, the UNION statement only select distinct values, while UNION ALL select all the values including the duplicates.