update query 1

[canett]

Can you help me with an update query? I want to update
the query sql in such a way, that the cartons should be
the same as branch0 and quantity as items0 in the folloiwng sql:

Dim sqlOnStock As String
SQLOnStock = " SELECT Products.Productid, roducts.branch0, Products.items0 FROM Products"

Dim sql1 as string
sql1 = "SELECT DISTINCTROW [Order Details].OrderID,
[Order Details].ProductID, [Order Details].Quantity,
[Order Details].cartons FROM Products INNER JOIN [Order Details] ON Products.Productid = [Order Details].ProductID
ORDER BY [Order Details].OrderID"

 

[PHV]

Like this ?
UPDATE [Order Details] AS D INNER JOIN Products AS P ON D.ProductID = P.Productid
SET D.cartons = P.branch0, D.Quantity = P.items0

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886