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