Wednesday 10 April 2013

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