hi all,
can we write a trigger in such a way that same trigger is fired when any query executes for two different tables.
i mean to say,
i have two tables tbla, tblb. right now i have written one trigger which inserts in tblc whenever there is any insertion, deletion or updation in tbla. now what i want is can i insert in tlbc itself when i have insertion, or deletion or updation in tblb also at the same time. some field of tbla and some field of tblb.
ie
tbla contains name, address
tblb contains tel,mailing_add.
now when a trigger is fired, then tlbc should contain tbla.name, tblb.mailng_add.
can it be done?
with regards,