Explore BrainMass

Union and Union All Operations in SQL

Please describe union and union all operations in SQL. What are some applications of these operations?

Solution Preview

In SQL the UNION operator combines the results of two SQL queries into a single table of all matching rows. The two queries must have matching fields and data types in order to join them. Any duplicate records are ...