Creating Views

Hey all,

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 - 15:27:24 CDT