Help in creating an update query

[jewelr]

Hello,
I need to create an update query to replace skus in one table if they match skus from another table. Say I have table "A" i created with 2 fields SKU and AltSKU. I need to create an update query that updates SKUs from table "B" if they match a sku from table "A". If the sku in table "B" matches a sku in table "A", then the sku in table "B" will be replaced by the AltSKU from table "A". I hope i explained that right. Thanks!

[ranman256]

answered on the Access forum

[jewelr]

Yes, Thanks again ranman256!