|Subject||Re: [ib-support] How to ORDER BY a field produced by a singleton select?|
At 04:37 25/12/2002 +1030, you wrote:
>The following is required for allowing ordering by a looked-up field that isORDER 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?