mysql - Attach historical data to a non-historical table -

i have 2 tables similar structure in mysql, 1 updated data , other history records data, , need perform analytics on data have there. thought using view aggregates data in 1 table useful i'm not sure how accomplish it.

why not create view using union?

create view my_view select field1 f1, field2 f2 table1 union select field1 f1, field2 f2 table2 

then perform analysis on view.

more docs: union, create view.