Thread: views and multiple tables?

views and multiple tables?

From
Dennis Gearon
Date:
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