[NEW][SQL] operator IN implemented

[Deane Venske]

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

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
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina