Table Unions

Use table unions to pull rows from tables that have the same structure. Table unions pull rows that exist in both tables. The Union option is available only if the rows in one table are also included in the other table.

Union All retrieves all the rows, even the duplicate rows, from the primary and secondary tables.