Concatenation
The Concatenation logical and physical operator scans multiple inputs, returning each row scanned.
(c) 1988-98 Microsoft Corporation. All Rights Reserved.