newbie sql question:

how would i insert records into a table or multiple tables based on the results of another query?

ie:

select a, b, c, from mytable

loop results

insert into mytable1 (e,f,g,h,i)
values (loop.a, loop.b, loop.c, other_value1, other_value2)

end loop



sorry if its basic..