Help on views

Hallo,

I have a question on views.

If I have a table e.g.
table a: id,name,street (NULL-Values allowed)

and I create a view like this:
create view test1 as
select name n1, name n2 from a;

(Well, maybe this makes no sense)

Question: What happens when I insert into the view values like this:

insert into test1 (n1,n2) values('George','Ben') ;

What will be inserted into table a?
Only 'George'?
nothing (error-message) ?

Thanks for help! Received on Sat Sep 15 2001 - 15:05:10 CDT