UNION ALL

A relational operator that combines all rows from two queries. Unlike UNION, the expression (A UNION ALL B) does not discard duplicates. UNION ALL can be applied to a streaming query - resulting in all rows from both streams being in the result.