need to retrieve data from one table and insert into another table

[getnitha]

hi

i want to retrieve data from one table using select query and needs to insert into a new table.i just want to select 5 fields(instead of 10) from the first table and insert these records into new table.rest of the fields data i need to calculate and insert ...so plse help me t find out one solution

 

[cjard]

hi

i want to retrieve data from one table using select query and needs to insert into a new table.i just want to select 5 fields(instead of 10) from the first table and insert these records into new table.rest of the fields data i need to calculate and insert ...so plse help me t find out one solution

INSERT INTO dest(c1, c2, c3, c4, c5)
SELECT a,b,c,d,e FROM source