About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.4.3
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1

Back Next

UNION ALL

The UNION ALL query combines the result sets of multiple SELECT statements. It returns all rows from the queries, including rows returned from more than one SELECT statement. It does not remove duplicate rows from the final result set.

Syntax

The UNION ALL operator has the following syntax:

SELECT column1 [, columnN ]
FROM table1 [, tableN ]
[WHERE clause]

UNION ALL

SELECT column1 [, columnN ]
FROM table1 [, tableN ]
[WHERE clause]

Examples

The following UNION ALL query returns all product IDs from the first and second SELECT statements:

SELECT product_id FROM order_items
UNION ALL
SELECT product_id FROM inventories;

The following UNION ALL query uses parentheses to specify the precedence of evaluation :

SELECT * 
   FROM departments
   UNION ALL
   (SELECT * 
   FROM warehouses
   UNION
   SELECT * 
   FROM offices);

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

UNION ALL

UNION ALL

Syntax