zagnutts
asked on
Advanced Update query
I have 2 tables:
Table 1
OrderID
ProductID
ItemQuantity
ItemName
ItemCost
Table 2
SessionID
ProductID
ItemQuantity
What I am trying to do is update Table1.ItemQuantity with values of Table2.ItemQuantity where their productIDs are equal.
Thanks for your help
Table 1
OrderID
ProductID
ItemQuantity
ItemName
ItemCost
Table 2
SessionID
ProductID
ItemQuantity
What I am trying to do is update Table1.ItemQuantity with values of Table2.ItemQuantity where their productIDs are equal.
Thanks for your help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.