Subject Re: [IBO] OrderLinks with multi join
Author Jason Wharton

You may need to define a view so that you can have a different relation name
to distinguish them with.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Brian Dunstan" <bdunstan@...>
To: <>
Sent: Wednesday, November 15, 2000 4:32 AM
Subject: [IBO] OrderLinks with multi join

> 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 = 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
> 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