Insert data of one table into other.

The following sql script is for insert data of one table into other table.

insert into table1(column1,column1,column3) select column1,column2,column3 from table2