i m having big trouble understanding them.... I thought of getting some explanation here..but..

thanks for your suggestion

sorry i couldn't get that.

Here is the actual table definition,view definition

create table table1

(id int,name varchar(10))

create table table2

(id int,marks int,grade varchar(2))

create view sampleview

as

select t1.name,t2.marks,t2.grade

from table1 as t1

join table2 as t2

on t1.id=t2.id

create trigger samptrigger

on sampleview

instead of...

with the help of that i did execute the trigger.but i could not be able to see the inserted row in view.can you help me in that

thank you

sorry to respond lately..

For creating instead of insert trigger on view.i am getting the following message

and the code that i prepared is

create trigger sampletrigger

on...

but i am trying to insert data on multiple base tables in a view.

thank you