select query + insert query

[maravinds]

Hallo everyone,

I have two tables in the database table1(col1,col3,col2) and table2(col1, col2). First of all i will have to select col2 from database and for each and every value of col2 i need o make an insert query in the table1(..,..,col2).

It will be helpful for me if anyone call solve this problem for me.

aravind.s

 

[maravinds]

hallo everyone,

i think that no one has understood my question.

eg : Table2 has the following rows

1 - 20
2 - 30
3 - 40

then Table1 must have the following rows generated automatically

1 - 10 - 20
1 - 10 - 30
1 - 10 - 40


thanks.