How to merge all multiple tables with a single blank table in SQL?
Posted on 2016-09-15
There are multiple tables, all tables are having same column names with different values, nd I have created one new table with same columns , but I want to put those all data in this new crated single table in SQL. There is no unique id in any of the table. I just want to merge all table data in one sinlge table.
Table names are - Andra Pradesh, Arunachal Pradesh, Assam, Bihar, Chhattisgarh,Delhi,Hariyana,Himachal Pradesh, Karnataka.
And all column names are same in all the tables , here is the column names - State, District,Year,January,February,March,April,May,June,July,August,September,October,NovemberDecember. And tbl_India this is the new table which I created with the same columns.... I want to add those all data in this new table.