Re: Order by sub-select

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;