Milan Babuskov wrote:

>
> Raymond Kennington wrote:
> > The following is required for allowing ordering by a looked-up field that is
> > computed.
> >
> > SELECT
> > A.ID,
> > A.NAME,
> > (SELECT B.NAME from B WHERE B.ID = A.BID) AS B_Name
> > FROM A
> > ORDER BY B_Name
> >
> > It doesn't work, so how should one do this?
>
> Try: ORDER BY 3

That works. Thank you. It also gave me an idea as to how make IBObjects'
OrderLinks work in this circumstance.

--
Raymond Kennington
Programming Solutions
W2W Team B


--
Raymond Kennington
Programming Solutions
W2W Team B