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: need help with sql

Re: need help with sql

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 02 Mar 2005 18:35:40 -0800
Message-ID: <1109817155.17106@yasure>


Malcolm Dew-Jones wrote:

> Starton X. Mangrove (desdfsdf_sdf393_at_yahoo.com) wrote:
>
> : Thanks for nothing. That query is equivalent to Select *
>
> No more so than your original query was.
>
> : Please read carefully before answering a problem.
>
> It appears he did.
>
> Your single query tries to accomodate two different situations. Mr Morgan
> has pointed out an alternative approach. Handle each situation in its own
> query, and combine the results.
>
> Perhaps you should read carefully before posting.
>
>
> : > Query where shared_id <> 0
> : > UNION (ALL)
> : > Query where shared_id = 0;
> : > --
> : > Daniel A. Morgan
> : > University of Washington
> : > damorgan_at_x.washington.edu
> : > (replace 'x' with 'u' to respond)
>
>
>
> --
>
> This space not for rent.

Thanks Malcolm as you are exactly correct. If Starton wants help in the future he has certainly started off on the wrong foot.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Mar 02 2005 - 20:35:40 CST

Original text of this message

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