insert data from one table to another in sql

Helo guys.. A simple way to insert data from one table to another



Insert into Table1(distcentre, distcode,disttname) select distributorcenter, UserCode,Name
from Table2