[NEW][SQL] operator IN implemented

[Ruslan Zasukhin]

on 6/2/03 4:37, Deane Venske at dean at eduss.com wrote:

> Does this mean we can do nested queries?
> IE -
> SELECT firstname FROM userDetails WHERE username IN (SELECT username FROM
> adminUsers);

Not yet. Nested query you cannot expand into OR statement.
But I am going to work on this kind of query right now.
 
> Deane
> 
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
> Zasukhin
> Sent: Monday, 2 June 2003 6:00 AM
> To: valentina at lists.macserve.net; David Studstill
> Subject: [NEW][SQL] operator IN implemented
> Importance: Low
> 
> 
> Hi Guys,
> 
> Implemented operator IN for SQL of 1.9.8
> 
> In the form:
> 
>   WHERE fld in ( v1, v2, v3, ... )
> 
> This operator work with any type and values for which you can write
> 
>   WHERE (fld = v1 OR fld = v2 OR fld = v3)

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------