Update Query - Not working

  • Thread starter Thread starter scharp1n2
  • Start date Start date
S

scharp1n2

I have attached my sql which does not seem to work.

UPDATE Material1A INNER JOIN war100708 ON Material1A.KishMaterialID =
war100708.KishMaterialID SET war100708.SKUNumber = Material1A!WARSKU;

It deletes the sku number from the original table (war100708) but it does
not seem to end up in the Material1A table.

I am using Access2003 -

Thank you in advance for any help on resolving this.
 
"it does not seem to end up in the Material1A table" because you are updating
the war100706 table with this set:
SET war100708.SKUNumber = Material1A!WARSKU
 
Thank you so much - you can not imagine how much time I wasted. It works
great now. Thanks again
 
Back
Top