That in the consultation that you sent wrote join instead of inner join

You have tried order by number of column?
for example: order by 1

Greetings
=========
¦¦ ISMAEL ¦¦
=========

----- Original Message -----
From: tomkrej
To: firebird-support@yahoogroups.com
Sent: Wednesday, February 03, 2010 1:17 PM
Subject: [firebird-support] Re: FB 2.1.3 - cannot order VIEW rows



--- In firebird-support@yahoogroups.com, "Ismael L. Donis García" <ismael@...> wrote:
>
> It should not be inner join instead of join
>

I don't understand what You want to say. On FB 1.5 it works properly.

When I change it to

inner join SUB_TABLE1 on ...
it doesn't work too.

I think that the use of inner or left join depends on the application logic and cannot cause the malfunction of ORDER BY sorting

Tom





[Non-text portions of this message have been removed]