Re: need help with sql

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.