Pls Help..Triggers

[Aman Gupta]

Hi

I did not create any SQL trigger or procedure before. What I need is that I have 6 tables as:
1- Parent1 [Employee]: EmpID (PK), EmpName ...etc.
2- Child1 [EmpCourse]: EmpID (FK), CourseName, ...etc
3- Child2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.

4- CopyofParent1 [Employee]: EmpID (PK), EmpName ...etc.
5- CopyofChild1 [EmpCourse]: EmpID (FK), CourseName, ...etc
6- CopyofChild2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.


CopyofParent1 columns is superset of Parent1 columns.
Similarly for CopyofChild1 and CopyofChild2.

As soon as a record in Parent1 is inserted and meets a certain criterion, the record shd be inserted in CopyofParent1 using EmpID .
At this time, records from Child1 and Child2 for the same Parent shd be inserted in CopyofChild1 and CopyofChild2 resp.


Please help.

Thanks

[Amit Ghorpade]

"cool again " please see your private messages for an important administrative matter.

[Aman Gupta]

Thanks Amit.I have updated the details.

[Paul Sturrock]

Which database are you using?

[Amit Ghorpade]

Thanks for the update