View vs. Table

Get this
1. I try to write a query for a tree

    select col1, col2, col3 from TABLE1     start with col3 is null
    connect by col2=col1;

    WORKS GOOD Here is my problem

2. I do the same thing but inted I am selecting from VIEW

    select col1, col2, col3 from VIEW1
    start with col3 is null
    connect by col2=col1;

...and it gives me an ERRORS....

3. My view sound like this

SELECT col1, col2, col3 FROM TABLE_A
union
SELECT col1, col2, col3 FROM TABLE_A
union
SELECT col1, col2, col3 FROM TABLE_A

4. ANY WORD OF WISDOM WHY IT IS WORKING FROM TABLE AND NOT WORKING FROM VIEW????? Received on Tue Aug 17 1999 - 01:20:28 CDT