Brian,

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

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Brian Dunstan" <bdunstan@...>
To: <IBObjects@egroups.com>
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 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
>
>
>
>