hi, good day for all , i having a problem , which is actually due with multiple insertion.
the scenario :
- i have a customer table, customerReferenceProduct table and product table
- customerReferenceProduct table have customerID and product_id, which actually use for keep track what are the product will show to customer
- let say, when user enter information for new product, all information will save into new product table, then this new product id will save into customerReferenceProduct table for all customer , so end up , we need to save all row that for each customer_id but with same product_id
below is my try sample
insert into customerTbl (customerid, productid)
select customerid from customer
//problem here, as productid is enter by customer, then how i include it ?
my problem is, when productid is user keyin data, but customerid is from customer table, how i include the productid for insertion ?