I have three tables which has the same schema. all of them has 10000000+ rows and has unique data as well as duplicate keys but with a datetime column can differentiate them and get the newest row.

I want to create a one combine table with all the data in my three tables updated with the newest records for duplicate values.

Suggest me a method to achieve this.