There are multiple tables. All tables have the same column names with different values. I have created one new table with the same columns. I want to put all those data into this newly crated single table. There is no unique id in any of the tables. I just want to merge all table data into one sinlge table.
Table names are - Andra Pradesh, Arunachal Pradesh, Assam, Bihar, Chhattisgarh, Delhi, Hariyana, Himachal Pradesh, Karnataka.
All column names are the same in all the tables. Here are the column names - State, District, Year, January, February, March, April, May, June, July, August, September, October, November, December. The new table which I created with the same columns is called tbl_India. I want to add those data into this new table.