From: | "Luis H(dot)" <pgsql-novice(at)geekhouse(dot)no-ip(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: ORDER BY question |
Date: | 2003-09-01 13:57:04 |
Message-ID: | 003601c37090$ecc79450$0200a8c0@atticus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks for the info! Group by should do the trick.
Why does replying to an unrelated message create an issue, btw? I changed
the subject, headers and contents of the e-mail. Or at least I thought I
did!
Also, why do people reply to both the message sender and the mailing list?
Doesn't it just arrive duplicated in the sender's mailbox.
Cheers,
- Luis
----- Original Message -----
From: "Bruno Wolff III" <bruno(at)wolff(dot)to>
To: "Luis H." <pgsql-novice(at)geekhouse(dot)no-ip(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Monday, September 01, 2003 3:04 AM
Subject: Re: [NOVICE] ORDER BY question
> Please don't start new topics by by replying to unrelated messages.
>
> On Sun, Aug 31, 2003 at 21:44:12 -0400,
> "Luis H." <pgsql-novice(at)geekhouse(dot)no-ip(dot)com> wrote:
> > I have two tables, table A contains users (id, username, password) , and
> > table B contains a row that signifies the 'owner' of each particular
entry,
> > referencing an id in A.
> >
> > What I want to do is do a query where I order table B by owner, but
> > alphabetically by username. The problem, obviously, is that table B only
> > contains id's (numbers, indexing to A), which don't correspond to the
> > alphabetical order of the usernames.
>
> You should do a join on A and B and then you can order the output by
> fields in both A and B.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jennifer Liu | 2003-09-01 16:06:19 | starting up database server + user postgres |
Previous Message | Nabil Sayegh | 2003-09-01 07:57:00 | Re: ORDER BY question |