We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


Update records from anothet table

skull52 asked
Medium Priority
Last Modified: 2012-05-11
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.
Watch Question

So what is your unique field to join on? You mentioned "I want to replace bad Item numbers".

Can you show an example of your data?
Top Expert 2011
Unlock this solution and get a sample of our free trial.
(No credit card required)
skull52IT director


Yes the ItemNumber is the primary key for both tables the corrected table has the wrong Item number in the first column and the correct item number and count in the second and third columns respectively. and the wrong itemnumber is in the combined count  
Top Expert 2011

does the above update work for you?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.