Unions allow queries with the same number of columns to be returned in one result set. For instance, if you have two tables storing user names, you can have all of the names in one query returned with a statement like this: