UNION Operation

Combines the results of two or more select statements.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Standards

Go to Permissions

Syntax

select-without-order-byUNIONALL ] select-without-order-by
   … [ UNIONALL ] select-without-order-by ]…
   … [ ORDER BY integerASC | DESC ] [, …] ]

Parameters

(back to top)

Examples

(back to top)

Usage

(back to top)

The results of several SELECT statements can be combined into a larger result using a UNION clause. The component SELECT statements must each have the same number of items in the select list, and cannot contain an ORDER BY clause. See FROM Clause.

If corresponding items in two select lists have different data types, SAP Sybase IQ chooses a data type for the corresponding column in the result, and automatically converts the columns in each component SELECT statement appropriately.

The column names displayed are the same column names that display for the first SELECT statement.

Note: When SELECT statements include constant values and UNION ALL views but omit the FROM clause, use iq_dummy to avoid errors. See FROM Clause for details.

Standards

(back to top)

  • SQL—ISO/ANSI SQL compliant.
  • SAP Sybase Database product—Supported by SAP Adaptive Server® Enterprise, which also supports a COMPUTE clause.

Permissions

(back to top)

Requires SELECT privilege for each component of the SELECT statements.

Related reference
FROM Clause
SELECT Statement