Re: 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@geekhouse.no-ip.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.