Update Query - Not working

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.
 
D

Duane Hookom

"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
 
S

scharp1n2

Thank you so much - you can not imagine how much time I wasted. It works
great now. Thanks again
 
Top