AR: Update Product Classes in Sales Detail

From KeystoneIntranet
Revision as of 12:58, 14 July 2023 by WikiAdmin (talk | contribs) (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)