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..