I have around 120 tables in my database. Monthly data for 10 years period . The tables have the same data type and number of columns(more than 20 columns). I want to combine these tables in 1 table. I am wondering what is the easiest way to do so.
I hope it is not by appending each table individually.