OR in WHERE

[Ruslan Zasukhin]

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