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

--

Milan Babuskov
http://fbexport.sourceforge.net