UNION ALL returns all rows from both the SELECT queries and it does not remove duplicate rows between the various SELECT statements.
