Update records from anothet table
Posted on 2011-04-20
I have a table CombinedCount with ItemNumber, Count, and ChngNote we had to correct some of the item numbers and counts as they were in wrong. I have exported the the corrected item numbers, counts and a reason for change to a table CorrectedItem with only the corrected items. I want to replace the bad Item numbers, count and add the notation to ChngNote in CombinedCount with the corrected Itemnumber, count and ChngNote from CorrectedItem I think it can be done with a sub query but I am not sure how.