OR in WHERE

[Ruslan Zasukhin]

On 5/20/04 7:18 PM, "keatk at comcast.net" <keatk at comcast.net> wrote:

>> 
>> Not works OR for fields that are in different tables.
> 
> THAT IS A MAJOR BUG ... SQL spec has no such limitation and OR across tables
> is common in anything more than a simple databse ...  and it has bitten me...
> and it does not even produce an error which makes it worst!

Agree.

But also note: 
    such kind of search is much harder (slower) of AND.
    
    if possible it is better change table design to avoid such kind of query
    even if it works in DBMS.

And you have workaround using IN (SELECT)
    

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