It should not be inner join instead of join

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

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



Hi, I'm using firebird 2.1.3 on Windows.

I have a VIEW that is constructed

CREATE VIEW VIEW_MAIN (
...
)
as
select distinct
...
from MAIN_TABLE
join SUB_TABLE1 on ...
left join SUB_TABLE2 on ...
where MAIN_TABLE.STATUS != 'V'

when I try to sort rows in view it doesnt work, and the row order is allways the same, order by clause is ignored

but, when I remove - DISTINCT, or change join SUB_TABLE1 to LEFT join SUB_TABLE1

view work properly.

Is this behavior OK?? I dont think so.

I can send the full source code for tests.

Thanks, Tom





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