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