Re: grouping

From: Jeff Guttadauro <jeff109_at_NOSPAM.netscape.net>
Date: Wed, 29 Sep 1999 14:14:59 GMT
Message-ID: <37f21e4a.1611296@news>

Could you give a little example of some data and what you're hoping the results will be? It's not very clear what you're trying to do from your post.

On Tue, 28 Sep 1999 18:18:37 GMT, ppaudyal_at_my-deja.com wrote:

>Hello,
> I have a table which has two fields called fid and parentid.
>I want to order the values in such a way that the 'fid' with value -1
>comes first, then the ones with
>'parentid = -1 ' comes. Then again, 'fid' with value '-1' and the ones
>with 'parentid = -1' comes.
>I can't think of a way to select the values in order so that.
>Any help would be appreciated.
>Thanks
>Pradeep
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Sep 29 1999 - 09:14:59 CDT