Select from one table and insert into another Table

INSERT INTO table-one

(

  -- Columns

)

SELECT 

  -- Columns

from    table-two

Example :

 

INSERT INTO Suburb

(

   suburb_id,

   suburb_name,

   state_id

)

SELECT 

   suburb_id,

   suburb_name,

   state_id

from    

   Suburb_Temp