|
Posted by info@bodykind.com on 12/14/06 09:56
The following query works fine in access and does exactly what I want
it to do however I get a syntax error when I port it over to SQL Server
2000.
-------------
UPDATE OrdersProducts INNER JOIN Products ON OrdersProducts.ProductID =
Products.ProductID SET Products.Stock =
Products.Stock-OrdersProducts.Quantity
WHERE OrdersProducts.OrderID=63116
--------------
Any help would be greatly appreciated
Many thanks
Navigation:
[Reply to this message]
|