With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I need prices updated in a MySQL table. There are 4 tables involved. The price value in one table needs to be updated by correctly joining the other 3 tables and taking the minimum value. I don't know how to do this in MySQL without creating a temporary table and have multiple steps in a PHP script. I'm sure a MySQL pro would easily know how to do this with one query.
Explaining again for clarity: There are multiple products in the main table that will need updating with this one query. Each product has multiple prices as related by the other tables. The product price should be updated to the minimum of these multiple prices.
I'll send a mysqldump of the database so you can complete job.
Sign in or Register to see more