Wednesday, December 28, 2011

UPDATE with INNER JOIN

Updating the quantity in inv_physicalstock table that not match in verification table

UPDATE INV_PHYCALSTOCK SET QTY=ACTUAL_STOCK FROM VERIFICATION V INNER JOIN INV_PHYSICALSTOCK P ON P.ITEMCODE=V.ITEMCODE WHERE V.ACTUAL_STOCK<>P.QTY

No comments: