Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

mqiojfei


 / Published in: PL/SQL
 

  1. UPDATE s_product
  2. SET total_in_stock = (SELECT SUM(amount_in_stock) FROM s_inventory WHERE product_id = s_product.ID);

Report this snippet  

You need to login to post a comment.