Union

Union All

The UNION ALL operator concatenates results from one or several SELECT statements.

select_stament
UNION ALL
select_stament

Union Distinct

The UNION DISTINCT operator concatenates results from one or several SELECT statements and only return the distinct rows.

select_stament
UNION DISTINCT
select_stament