Hmm.. it should work, but maybe it's a bug in IB engine (?) when using 2 join conditions.

Btw, what is your client? I can give some workaround if you're using Delphi, just use TClientDataSet and don't ask IB to order your query, but instead add an index to TClientDataSet effectively telling the client to do the sorting.

On Tue, Jul 03, 2001 at 12:58:10PM +0100, Pete Bray wrote:
> thanks Svein,
>
> Interesting. I had already tried the 'order by p.name' but got a complaint
> because i had wrongly assumed that i used the alias in the order by clause.
>
> Kind regards,
> Pete