My query :

```
insert into fakjual_detail(no_fakjual,date_fakjual,id_cur,vehicle_id,price_fakjual,qty_fakjual,amount_fakjual,ppn_fakjual,total_fakjual,bap_fakjual,sta_fakjual_det,act_fakjual_det,id_user)
select nofakjual,datefakjual,idcur,vehicle_id,price_spk,qty_spk,amountfakjual,ppnfakjual,totalfakjual,bapfakjual,stafakjualdet,actfakjualdet,iduser from spk_detail 
where spk_detail.`no_spk` = nospk

```

The query is run well if table spk\_detail only have one record. the problem is when table spk\_detail have two records then the record that I insert to fakjual\_detail will be 4 records (2 each from table spk\_detail)

Ex : 
table spk\_detail have record Apple, Orange for Fruit, then result on fakjual\_detail will be Apple, Orange, Apple, Orange

**UPDATE**
Table Structure :

```
spk_detail : vehicle_id, no_spk, price_spk

fakjual_detail : id_fakjualdet (auto increment), vehicle_id, price_jual

```

I Want to insert the vehicle\_id and price\_spk from spk\_detail to fakjual\_detail where no\_spk = nospk (parameter from vbnet)

Please help. sorry for my bad english. Thank you