This project is read-only.

UNION

Combines the results of two or more queries into a single collection.

Syntax

expression UNION expression

Arguments

expression: Any valid query expression that returns a collection to combine with the collection All expressions must be of the same type or of a common base or derived type as expression.

Return Value

A collection of the same type or of a common base or derived type as expression.

Example

(select p.ProductID, p.ProductName from Products as p where p.UnitPrice < 100 )
union
(select p.ProductID, p.ProductName from Products as p where p.UnitPrice > 200)

Last edited Mar 12, 2013 at 9:28 AM by ansiboy, version 2

Comments

No comments yet.