Re: creating views with mulitple tables

You can now update to any number of tables in a view. You will need Oracle 8 and you will need to write instead of triggers on the view.
Check out the documentation to see how to do this.

Also, updatable views are very useful. However, only one of the tables can be updated in any one view.

Sybrand, I don't think you needed to be quite that hard on Kenny. It takes a while for people to get the hang of list etiquette.

--
Paul Dorsey
Dulcian, Inc.
www.dulcian.com
212 595 7223

P.S.
If you would like to talk to Dulcian about a salaried position on our team,
please call me.
We have openings in NJ for developers, in CA for PERL developers.




Kenny wrote in message <37BDBD9D.632DB00E_at_erols.com>...


>hey gang,

>

>two part question:


>

>first, i am trying to create a view selecting from two tables.  the

>column names are the same in both tables, and they are primary keys in

>the corresponding tables.  my question is, if after i create the view,

>and then i insert, update, or delete from that view, will it flow down

>to the underlying tables?

>

>secondly, i am having trouble with the syntax of the create view. i know

>its something like:

>

>create view combo as select cust_id, first_name, last_name from

>customer  ( now here is where i dont know how to join the other table, i

>would like to also select cust_id, first_name, and last_name from

>another table called preference)

>

>any help would be GREAT!

>cheers

>-Kenny

>

>please respond to kenny_at_on2.com

>