lo, I have two tables products and Prices. The following four fields are in question products.products_model, products.products_price, Prices.Model and Prices.MSRP.
The goal is to do a join on products.products_model with Prices.Model, and update the products.products_price with Prices.MSRP.
I tried the following syntax but it returns an error that I should check my MySQL version (i've got verison 5)
UPDATE products
SET products.products_price = Prices.MSRP
FROM products, Prices
WHERE products.products_model = transactions.transaction_id
The goal is to do a join on products.products_model with Prices.Model, and update the products.products_price with Prices.MSRP.
I tried the following syntax but it returns an error that I should check my MySQL version (i've got verison 5)
UPDATE products
SET products.products_price = Prices.MSRP
FROM products, Prices
WHERE products.products_model = transactions.transaction_id