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