Hello guys, i'm new using firebird, and i'm having some trobles with a
order by in a sql union statement.

For example..
select * from clients where id > 100

union

select * from clients where id < 200

order by date

Doesn't work, but if i run the sql without the "order by" it works just
fine.

Thanks anyway!

--
Rosivaldo Azevedo Ramalho
rosivaldo@...
+55 83 8803 0969