Subject Re: [IBO] OrderLinks with multi join
Author Svein Erling Tysvær
You can use their literal numbers rather than the field name, e.g.

select a.desc first_desc, b.desc second_desc from main x
join descriptions a on = x.id1
join descriptions b on = x.id2
order by 2

will order by b.desc. Take a look at Tutorial3 in the BasicTutorials
included with IBO for information about OrderingLinks (there may be some
other tutorials/samples as well, I don't know).


At 19:32 15.11.2000 +0800, you wrote:
>How is it possible to use OrderingLinks to define sort order on multiple
>columns of the same name.
>select a.desc first_desc, b.desc second_desc from main x
>join descriptions a on = x.id1
>join descriptions b on = x.id2;
>I want the user to be able to search on a.desc or b.desc, but I can't figure
>out the OrderingItems syntax that will allow it. I can arrange for the
>initial sort to use a.desc or b.desc OK, but the grid does not recognize
>that either column can be ordered, so the user can't change the order by
>clicking on the title bar.
>Any help gratefully appreciated,