thank u

I need the another approach(other than trigger and update cascade)..If any Please do reply

Hi,

If there are many child tables which are reffering to the parent table then?

I got the answer with both the options . Is there any option other than Trigger,on update cascade

Hi,

create table dc(id int,doctor_name varchar(20),date datetime,patient_name varchar(20),medicine int)

insert into dc values(111,'dr.Smith','01/01/2010','Mr.Jerry',123)

insert into dc values(111,'dr.Smith','01/01/2010','Mr.Jerry',456)

insert into dc values(111,'dr.smith','01/01/2010','Mr.Jerry',678)

insert into dc values(112,'dr.smith','01/02/2010','Mr.kk',999)

insert into dc values(112,'dr.nn','02/02/2010','mr.kk',88)

select * from dc

select id,count(*)...

Thanks Very much

Ya.. But how can we do the same with 1,2,3 empid's.

Thanks For giving the solution.

after inserting these two records to the previous records we need to get the result as:

insert into sales values(2011,01,100)

insert into sales values(2011,12,10)

ans:

20101110110

20102220330

20103330660

201044401100

201055501650

201066602310

201077703080

201088803960

201099904950

20101011006050

20101112107260

20101213208580

201111008680

201112108690