Advertisement
Guest User

Untitled

a guest
Apr 20th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.64 KB | None | 0 0
  1. UPDATE plt_stock PS
  2.     JOIN (
  3.         SELECT c_product_sku FROM plt_stock WHERE ifnull(c_synced,'') != 'T' GROUP BY c_product_sku
  4.         ) PSF ON PS.c_product_sku = PSF.c_product_sku
  5.     LEFT JOIN plv_item_simple PIS ON PS.c_product_sku = PIS.c_product_sku AND ifnull(PIS.c_product_sku,'') != ''  
  6. SET c_synced = 'T', c_error_msg = 'Product SKU does not exists'
  7.   WHERE PIS.c_product_sku IS NULL
  8.  
  9. UPDATE plt_stock PS
  10. LEFT JOIN plv_item_simple PIS ON PS.c_product_sku = PIS.c_product_sku AND ifnull(PIS.c_product_sku,'') != ''  
  11.     SET c_synced = 'T', c_error_msg = 'Product SKU does not exists'
  12.         WHERE PIS.c_product_sku IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement