I'm trying to zero the Reorder points and restock levels, for branch 2 and category 546.
What's wrong with the statement below, it zero's everything for branch 2.
UPDATE Itemdynamic
SET itemdynamic.Reorderpoint ='0', itemdynamic.restocklevel ='0'
FROM itemdynamic, item
WHERE itemdynamic.storeid = '2'
AND item.categoryID = '546';