Insert multiple rows of the select query

Hello all,

I have a procedure, and want to insert the rows return to 2 table, however, i only get the first row inserted,

item_no, Price

1              100

1              200

the item_no insert into table 1

price insert into table 2

my current insert is 

insert into

table1

(item_no)

values(1);

insert into table2

(price)

what am i missing to insert all the rows return to table for price?