Copy reference code to supplier reference

[SoluNOiD]

Hi out there,

Is there anybody with SQL knowledge who can help me?

I want to copy all of my products reference code to the supplier reference. I have tried with the below script with the supplier id as anchor, but it doesn't seem to work at all.

UPDATE tbru_product_supplier INNER JOIN tbru_product_attribute USING (id_product, id_product_attribute) SET product_supplier_reference = reference WHERE id_supplier = 1

 

BR

Stephan