This project is read-only.

Except

Returns a collection of any distinct values from the query expression to the left of the EXCEPT operand that are not also returned from the query expression to the right of the EXCEPT operand. All expressions must be of the same type or of a common base or derived type as expression.

Syntax

expression EXCEPT expression

Arguments

expression: Any valid query expression that returns a collection to compare with the collection returned from another query expression.

Return Value

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

Examples

(select p1.ProductName from Products as p1 where p1.CategoryID = 2)
except
(select p2.ProductName from Products as p2 where p2.CategoryID = 3)
(select p1 from Products as p1 where p1.CategoryID = 2)
except
(select p2 from Products as p2 where p2.CategoryID = 3)

Last edited Mar 12, 2013 at 8:49 AM by ansiboy, version 1

Comments

No comments yet.