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 a.id = x.id1
join descriptions b on b.id = 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).

Set

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.
>
>EG:
>
>select a.desc first_desc, b.desc second_desc from main x
>join descriptions a on a.id = x.id1
>join descriptions b on b.id = 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,
>
>Thanks,
>
>Brian
>
>
>
>
>