At 02:04 AM 10-01-02 -0400, Claudio Valderrama C. wrote:

>""Richard Pendered"" <rpendered@...> wrote in message
>news:000c01c1984b$5196efe0$208282c1@tipadrrp...
>> Does Firebird RC2 support "order by" in views yet ?
>
>[...]
>As you can see, the standard considers the sorting clause apart from the
>query expression and a view only allows a query expression. Hence, both IB
>and FB agree to the standard by not allowing ORDER BY in a view definition.

..but you can do

select * from aView
order by aColumn

H.

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________