sabiqisback
I cann't be coool
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment