AR: Update Product Classes in Sales Detail

From KeystoneIntranet
Revision as of 00:01, 10 January 2017 by Intra>User (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Update the product class in Sales Detail table from the Product Table

update artslsdt d
set d.product_class=
  (select product_class from artprod p where p.product_code=d.product_code)
where d.product_class<>
  (select product_class from artprod p where p.product_code=d.product_code)