creating views with mulitple tables

From: Kenny <>
Date: Fri, 20 Aug 1999 16:42:05 -0400
Message-ID: <>

[Quoted] hey gang,

[Quoted] 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!

please respond to Received on Fri Aug 20 1999 - 22:42:05 CEST

Original text of this message