Skip site navigation (1) Skip section navigation (2)

Re: Order by sub-select

From: Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com>
To: "Daniel T(dot) Staal" <DStaal(at)usa(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Order by sub-select
Date: 2008-01-09 17:39:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Jan 9, 2008 12:12 PM, Daniel T. Staal <DStaal(at)usa(dot)net> wrote:
> How would I sort the result by eforward.partner.ibx?

Try (untested):

SELECT DISTINCT name, contact, phone, email
FROM            eforward.address
                JOIN eforward.ibox
                ON eforward.address.gsb = eforward.ibox.gsb
                JOIN eforward.partner
                ON eforward.ibox.ibx = eforward.partner.ibx
WHERE           eforward.partner.pibx = 'MTCBIN'
ORDER BY        eforward.partner.ibx;

In response to


pgsql-novice by date

Next:From: Daniel T. StaalDate: 2008-01-09 18:09:44
Subject: Re: Order by sub-select
Previous:From: Daniel T. StaalDate: 2008-01-09 17:12:21
Subject: Order by sub-select

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group