Update Query Help

[kellan4459]

I have a table that has product_id, product_price, product_category, product_price_discounted

I want to update the product_price_discounted by multiplying the product_price by .85 for all items where product_category = 1,2,or3

This is new to me so I'm needing some help.

 

[r937]

I want to update the product_price_discounted by multiplying the product_price by .85 for all items where product_category = 1,2,or3

watch how closely the SQL mirrors what you said ...

UPDATE daTable
   SET product_price_discounted = product_price * .85 
 WHERE product_category IN ( 1,2,3 )

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[kellan4459]

I was way over thinking that ... thanks