SQL Update values in table A with multiple values from table B
I'm trying to update products' prices in table A with prices from table B
based on their product code.
There are about 50,000 products in table A but only 200 in table B. So I
want those 200 prices in table B to replace the prices of those products
in table A by matching the product code in both tables.
Can anyone advise me on how to go about doing it?
No comments:
Post a Comment