how to update pricing in products table

[2424]

I would like to update the pricing of the products in my products table from the excel sheet provided by the manufacturer.

I want to change only the prices that are different.

here is what i have so far.

UPDATE PRODUCTS SET products.price = vendor.price
WHERE products.partnumber = vendor.partnumber and products.price <> vendor.price;


thanks in advance

 

[SBendBuckeye]

Drop that in an update query and you should be good to go. Or are you getting errors of some sort?

Good Luck!

 

[2424]

I had the wrong update statement. I appreciate the suggestion.

Thanks again.