Mastering Oracle SQL, 2nd Edition

Through Oracle8i, the following restrictions apply to hierarchical queries.

• A hierarchical query can't use a join.

• A hierarchical query cannot select data from a view that involves a join.

These restrictions were removed with the release of Oracle9i.