176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MySQL Query Needed (Simple job for MySQL pro)
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sun, Aug 12, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: About $20
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need prices updated in a MySQL table. There are 4 tables involved. The value in one table needs to be updated by joining the other 3 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.

I'll send a mysqldump of the database so you can complete job.

Thanks.

Sign in or Register to see more

Desired Skills
MySQL Administration
Job ID: 32675181
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Armenia  |  
More than 7 years of work experience in PHP web development and C# .NET desktop applications development. Over 2 years of work experience with...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32675340  |  Submitted: Aug 12, 2012 11:45 ET 
Proposal SEALED

 Kenya  |  
Winner
Happy to work with you in any of these web technologies: Laravel 4, Codeigniter, Wordpress, RESTful Web Services (REST APIs), PHP, MYSQL and use...
2
  |  
 4.7   |  Private   |  17 Jobs
Bid ID: 32675307  |  Submitted: Aug 12, 2012 11:42 ET 
Delivery
Within 1 day
$20.00
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »