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

The UNION operator combines the result sets of multiple SELECT statements but does not include duplicate rows in the final result set. The final result set contains only distinct rows from all the SELECT statements.

Syntax

The UNION operator has the following syntax:

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

UNION

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

Examples

The following UNION query selects the same number of columns from different tables:

SELECT location_id, department_name, 
   FROM departments
   UNION
   SELECT location_id, warehouse_name 
   FROM warehouses;

The following UNION query selects all columns from multiple tables that have the same number of columns of the same datatype:

SELECT * 
   FROM departments
   UNION
   SELECT * 
   FROM warehouses
   UNION
   SELECT * 
   FROM offices;

The following UNION query includes an ORDER BY clause:

SELECT City 
FROM Customers
UNION
SELECT City 
FROM Suppliers
ORDER BY City;

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

UNION

UNION

Syntax