Hello All,
We have 3 tables table1, table2 and table3. table2 is exact replica of table1 along with some additional columns.Table3 stores columns whose values should be captured from table1.
Table1 with 5 columns a1,a2,a3,a4,a5 table2 has columns a1,a2,a3,a4,a5,a6,a7 table3 has columns b1 and b2. Table3 has b1 column which stores columns from table1 .Like it can have a1,a2,a3.
Is it possible to have insert on table from table1 depending on columns stored in table3.
Thanks and Regards,
Amrit