[NEW][SQL] WHERE fld IN (SELECT ...) implemented

[Ruslan Zasukhin]

on 6/2/03 23:53, David Studstill at david at artsystems.com wrote:

> Alright!  So that means SELECT * FROM Table1 WHERE x IN (SELECT x FROM
> Table2) will work?

YES

> How about NOT IN?

I need to check this. Good point.

>  ...and how about SELECT * FROM Table1 WHERE x IN (1, 2, 3, 4) ???

I have made this yesterday. As well as BETWEEN.
I did send you notifications.

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