I have the issue while inserting data from product table which contains 3 rows with quote\_id =1 I am only able to get first one from product to price table. 

Code to insert in price

```
db.execsql("insert into price (name, quantity ) values ((select from product title, quantity where quote_id =1 )  )   " )

```

Updated :

i want to insert a static id of one in same statment;
value = 1;

```
insert into price (price_id,name, quantity,row_total) 
"+value+",select title, quantity,SUM(price*quantity) 
from product where quote_id = 1

```

Something this i want to acheive this