Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql query build question

Re: sql query build question

From: Dmitry E. Loginov <dmitry_loginov_at_mtu.ru>
Date: Wed, 21 Nov 2001 21:02:52 +0300
Message-ID: <9tgs3d$veo$1@gavrilo.mtu.ru>

"Michael L. Hostbaek" <michDEL_THIS_at_bsd.fr.eu.org> wrote in message news:slrn9vnoq5.1u6l.michDEL_THIS_at_freebsdcluster.dk...
> hey...
>
> I have a question that has been bugging me for quite a while.
>
> I would like to build a query string, that says I want all where
> something = Y and all where somewhat = Y...
select * from your_table
where something=y or somewhat=1

>
> Let's say that, no entries in my base has somewhat = Y AND something = Y
> , but I would like to get all the ones where something = Y and all the
> ones where somewhat = Y -but I would like only to issue one query... is
> it possible ?
>
> Any help is MUCH appreciated..
>
>
> --
> Regards,
> Michael L. Hostbaek
> -= Thanks for all the fish.. =-
>
Received on Wed Nov 21 2001 - 12:02:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US