Might be close:

SELECT A.SOME_FIELD, B.ANOTHER_FIELD AS OTHER_FIELD
FROM TABLE A
JOIN ANOTHER_TABLE B ON B.XXX = A.XXX
ORDER BY B.ANOTHER_FIELD

----

John Elliott wrote:

>
> I would like to order a dataset on a singleton select field... example:
> SELECT SOME_FIELD,(SELECT ANOTHER_FIELD FROM ANOTHER_TABLE) AS
> OTHER_FIELD ......
>
> In this example order the dataset by OTHER_FIELD. Anyone know if this can be
> done?
>
> Thanks in advance.
>
> John Elliott
> john@...
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/