UNION returns all rows from both the SELECT queries after removing duplicate rows between the two SELECT statements.
