Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.40 KB | None | 0 0
  1. update fahasa_special_stock_sku sss
  2. join fhs_catalog_product_entity pe on pe.sku = sss.sku
  3. join fhs_catalog_product_entity pe1 on pe1.sku = sss.special_sku
  4. JOIN fhs_catalog_product_entity_decimal price ON pe.entity_id = price.entity_id AND price.attribute_id = 75
  5. JOIN fhs_catalog_product_entity_decimal price1 ON pe1.entity_id = price1.entity_id AND price1.attribute_id = 75
  6. set price1.value = price.value;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement