Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update fahasa_special_stock_sku sss
- join fhs_catalog_product_entity pe on pe.sku = sss.sku
- join fhs_catalog_product_entity pe1 on pe1.sku = sss.special_sku
- JOIN fhs_catalog_product_entity_decimal price ON pe.entity_id = price.entity_id AND price.attribute_id = 75
- JOIN fhs_catalog_product_entity_decimal price1 ON pe1.entity_id = price1.entity_id AND price1.attribute_id = 75
- set price1.value = price.value;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement