Re: Order by sub-select

On Jan 9, 2008 12:12 PM, Daniel T. Staal <DStaal@usa.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;