Hi All,
I have a requirement Like:
Having two tables t1,t2 with two columns each. I have one more table which is a history table t3 having four columns.
Structure is:
-----------
t1 --first table
Col1
Col2
-----------
t2 --second table
Col3
Col4
-----------
t3 --final table
col1
col2
col3
col4
---------------
These four columns in t3 are combination of t1 and t2.
My requirement is: I need merging of data from t1 and t2 into t3.
Condition is, t1,t2 could have millions of records. I need to update t3 whenever new rows in t1 or t2 get updated.
Any one who can help me to achieve my requirement?
I have a immediate requirement and unable to solve the issue.
Its very very urgent
Rgds,
Nadeem