Help: SELECT FROM (subquery) ? Is it possible?

[Quoted] [Quoted]     I have a problem concerning subqueries and ORDER BY. I have a query [Quoted] [Quoted] which select a number of records and then does some ordering of them (using [Quoted] [Quoted] CONNECT BY). However, I want to ORDER the table the SELECT operates on, like this:

SELECT *
[Quoted] [Quoted] FROM (SELECT * FROM sometable ORDER BY something) WHERE ...
< connect by stuff >

instead of

SELECT *
FROM sometable
WHERE ....
< connect by stuff >

However, this doesn't seem to work. Why? Is there a way to do this. The [Quoted] problem I have that I can't order after the CONNECT BY, as this screws up [Quoted] the nice tree-like structure the CONNECT BY made.

Thanks in advance,

• Peder