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;