The manual mentions:
"CREATE VIEW will define a view of a table. The view is not physically
materialized. Instead, a query
rewrite retrieve rule is automatically generated to support retrieve
operations on views."
It says nothing about whether that select statement can access MULTIPLE
tables, which I think would be one of the best benefits of a view, an
'unnormalized view' of some data, to work on data sets, not tables.
So can views be created with a select statement which selects from
multiple tables?
--
Carpe Dancem ;-)
-----------------------------------------------------------------
Remember your friends while they are alive
-----------------------------------------------------------------
Sincerely, Dennis Gearon