Creating Views

From: Kenny <karosenb_at_erols.com>
Date: Fri, 20 Aug 1999 16:27:24 -0400
Message-ID: <37BDBA2B.DC7D3311_at_erols.com>



[Quoted] Hey all,

[Quoted] Two part question:

First, I am trying to create a view that joins two tables, both tables having the same primary key. After creating the view, if I then insert, update, or delete a record from that view, will it affect both tables?

Second, Can someone tell me the syntax of joining two tables in the create view statement.

I know its something like:

create view combo as select cust_id, first_name, last_name from customer ( here is the part where I want to also select cust_id, first_name, last_name from another table called preferences)

Any info would be great..
Regards
-Kenny

p.s. please respond to my email
karosenb_at_erols.com Received on Fri Aug 20 1999 - 22:27:24 CEST

Original text of this message