Update ProductPrice column in one table from saleprice column in another table

amdivoff 0 Newbie Poster

15 Years Ago

Hi,
I would like to update the products table "ProductPrice" with the value "saleprice" from the distpricelist by matching the sku.
the "products" table is permanent, I upload a csv file and fill the "distpricelist" with the new data. so basically i need help with a mysql statement to update the fields.

product table
ProductID
ProductSKU
ProductName
ProductMSRP
ProductPrice
ProductWeight

distpricelist
sku
cost
saleprice

Thank You for any help

Andre

mysql

1 Contributor
0 Replies
43 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.