UNION From SQL Optimizer for IBM DB2 z/OS previous page next page UNION Combine rows from multiple tables and remove duplicate rows. A UNION construct contains a UNION node and at least one subtree. Each subtree contains a WFSCAN node, a WORKFILE node, a SORT node, and the source query block node. previous page start next page