I need to update values form one table to another and create values if they are not there
How can I do this for all values or form values from one ID to another
This is the query but I need to run it for every ID and that is a lot of job, so is there any simplier way?
So id_product is always the same
`
INSERT INTO ps_product_supplier
(id_product_supplier, id_product, id_product_attribute, id_supplier, product_supplier_reference, product_supplier_price_te, id_currency)
VALUES(NULL, 6216, 0, (SELECT id_supplier FROM ps_product WHERE id_product = 6216), (SELECT supplier_reference FROM ps_product WHERE id_product = 6216),
(SELECT wholesale_price FROM ps_product WHERE id_product = 6216), 3);
`