|Subject||Re: [ib-support] How to ORDER BY a field produced by a singleton select?|
Raymond Kennington wrote:
> The following is required for allowing ordering by a looked-up field that isTry: ORDER BY 3
> (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?