sql loop?

[Szhark]

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

[Amy00]

Not Sure if this is what you want:

insert into mytable1 (e,f,g,h,i)
select a,b,c,d,e
from table2,table3...
where table2.XX=table3.XXX
and ...