creating views with mulitple tables

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 Received on Fri Aug 20 1999 - 15:42:05 CDT