Hi,
Use the below query
INSERT INTO dt2 VALUES as
SELECT col1,col2,col3 FROM dt1
Please make sure that data type and length of subsequent columns are same.
You can also specify column name in table 2 on which column you want to insert data.
as below
INSERT INTO dt2<columns name in which you want to insert the data.> VALUES as
SELECT col1,col2,col3 FROM dt1