> I have a query with the following script
> select pkey
> ,afield
> ,lkey
> ,yesno
> , (select lname
> from ltable
> where ltable.pkey=mtable.lkey) as lname
> from mtable
>
> my question is there a way to set the ordeing on lname without ibo
> responding with an error "SQl error -206 Column unknown"
> I want the user to be able to search and sort on lname
> Please help

Instead of ...order by lname you can use ...order by 4 as lname is the
4th field of your query

Florian