OR in WHERE

[Andrew Sinning]

Thank you.  I think I get it now!

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: Thursday, May 20, 2004 11:03 AM
To: valentina at lists.macserve.net
Subject: Re: OR in WHERE


On 5/20/04 6:58 PM, "Andrew Sinning" <andrew at learningware.com> wrote:

> Ruskin,
    ^^^^^^^^^ Ruslan


> The query which you provided uses an AND, and results in cases where
> BOTH cases match.
>
> I need the cases where EITHER case matches.
>
> Valentina is a very good product, the bug with OR in WHERE not working
> is very significant.  I need to understand both a theory and a method
> for a work around of the OR bug.  Please help me.

Then you can use clause

    WHERE fld IN (SELECT ... )

Example:


    SELECT iId
    FROM infos
    WHERE
        infos.iID IN (SELECT introId FROM questions)
     OR
        infos.iID IN (SELECT infoId FROM questions)




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