This is probably obvious but I am a bit 'rusty' with my SQL and so I am missing it. I have 2 tables: Branch Daily Inventory and DAILY_INV2. Branch Daily Inventory is branch, date, and inventory levels of various products (structure needed for join with another table). DAILY_INV2 is an intermediary conversion table and is branch, date, product id, quantity and storage location. I am trying to set the quantity for a particular product in the Branch Daily Inventory based on the quantity value from the matching row in the DAILY_INV2 table. Here is my SQL... UPDATE [Branch Daily Inventory] INNER JOIN DAILY_INV2 ON ([Branch Daily Inventory].Date = DAILY_INV2.Date) AND ([Branch Daily Inventory].[SAP Plant ID] = DAILY_INV2.[SAP Plant ID]) SET [Branch Daily Inventory].[3360I] = [DAILY_INV2].Quantity WHERE (((DAILY_INV2.[Part Number])=3360) AND ((DAILY_INV2.[Storage Location])="1")); The test run lists values of all zeros which is not the correct result. Any insight?