Re: multiple tables

bob_at_coolgroups.com wrote:
> Anyone know how to put multiple tables in a single materialized view?

create materialized view myview as
select mytab1.mycol1,mytab2.mycol2
from mytab1,mytab2
where ...

is this the answer to your question?

br,
stephan Received on Wed Aug 02 2006 - 02:59:45 CDT