I have a select that works fine.  However, it doesn't work fine when I try to create a view of the result set.  There is nothing particularly fancy about the query, just a plethora of outer joins from the main table to the secondary tables.  I get an error back about one of the tables not existing, but like I said, it works as a select, just not as a create view as ... 
 
FWIW Oracle 8.0.6 on DG-UX
 
Dan

Reply via email to