I have a table1 with roughly 40 columns. I have created table2 like table1 but included few more columns. That is because I have 4 tables like table1 and now want to combine them all into one table, table2.
If I try INSERT INTO table2 SELECT * FROM table1
I get the error that column numbers are not the same. Is there a question to do this thing without writing all of the columns?
Thank you
04-22-2021 11:25 PM