Subject Re: [firebird-support] Re: FB 2.1.3 - cannot order VIEW rows
Author Ismael L. Donis García
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

¦¦ ISMAEL ¦¦

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

--- In, "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


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