This project is read-only.

In

Determines whether a value matches any value in a collection.

Syntax

value [ NOT ] IN expression

Arguments

value: Any valid expression that returns the value to match.
not: Specifies that the Boolean result of IN be negated.
expression: Any valid expression that returns the collection to test for a match. All expressions must be of the same type or of a common base or derived type as value.

Examples

select o from Orders as o where o.OrderId in { 1, 2 ,3 }
select o from Orders as o 
where o.OrderId in ( select value d.OrderId from OrderDetails as d )

Last edited Mar 12, 2013 at 9:21 AM by ansiboy, version 1

Comments

No comments yet.