Table Relation

Question

How to update two table while insert value into new table? For eg: I have table named table0table1 and table2. And I have datas in table0. While inserting table1 how to update as the inserted value to be deleted from table0 and the value to be inserted in table2.?

sujay anand · Answer

Here in my code I am inserting at the same time I am updating another table. My prob is I want to Update two table while inserting a first table and first table is not empty.

Kunal Vaishya · Answer

Hi You can use trigger on INsertion for this may be it will help you. Regards Kunal.