Subject Re: FB 2.1.3 - cannot order VIEW rows
Author tomkrej
--- 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