Compare and update data between two databases
Posted on 2016-10-04
I was helped by one of the members with the query below, but a closer look at the query doesn't works. Any assistance greatly appreciated. Thanks!
Here is the query:
SET [Available Inventory] = (SELECT [Available Inventory]
FROM Items_Update.. Updates U
WHERE U.[Item Number] = Items.[Item Number])
Example per screenshot:
- The query compare the 'Item Number' between the Inventory and Items_Update databases.
- If the Item Number matches, then update the "Available Inventory" number, which is 22 to the "Available Inventory" field in the Inventory database.