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);