Re: need help with sql

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)