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 help
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

Job awarded.

Mar 7, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Mar 06, 2013
  • 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: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Hi,

I have a query that is pulling data from multiple tables like this:

SELECT * FROM product, product_description, product_special WHERE product.product_id > 0 && product.product_id = product_description.product_id OR product.product_id = product_special.product_id ORDER BY date_added DESC LIMIT 0,100


Here's the table structure:

**product table
product_id
name
price
quantity

**product_description table
product_id
description

**product_special
product_id
special_price


Here's how I want the data displayed in a web browser: (note: if special_price exists, then display it. If there is no special_price, show all other data.)

product_id, name, price, quantity, description, special_price



Problem:
If there is no product_id entry in the product_special table, then the item will not show.

If there is an entry in the product_special table, show it and the rest of the item data.
If there is no entry in the product_special table, show the rest of the data.

Questio...

Sign in or Register to see more

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

 Canada  |  
Skilled .NET developer with 4+ years of experience, proficient with MSSQL and MySQL database engines. Also experienced with Web Scraping and...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38739490  |  Submitted: Mar 7, 2013 12:17 ET 
Proposal SEALED

 Bulgaria  |  
I have 3 years as Oracle PL/SQL developer. I've implemented Oracle E-Buiseness Suite(Oracle Financial) and Data Warehouse projects.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38727921  |  Submitted: Mar 7, 2013 07:33 ET 
Proposal SEALED

Hirdesh S.      
Hirdesh S.'s identity has been verified.  Learn More
 India  |  
I have expertise in Database development and Data warehousing:- Technical Skills:- 1) SSIS 2) SQL Server Development(Stored Procedures,...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 38727825  |  Submitted: Mar 7, 2013 07:31 ET 
Proposal SEALED

 India  |  
We are a small business on IT Development. We have worked with clients in USA and Malaysia. We do offshore development and maintenance work. We...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38725452  |  Submitted: Mar 7, 2013 06:29 ET 
Proposal SEALED

Elisha Nderitu Maitho      
Elisha Nderitu Maitho's identity has been verified.  Learn More
 Kenya  |  
A highly motivated ICT professional with good problem solving skills, fast learner and with a abililty to think outside the box to provide best...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38724825  |  Submitted: Mar 7, 2013 06:13 ET 
Proposal SEALED

 India  |  
I have good knowledge on SQL
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38720173  |  Submitted: Mar 7, 2013 04:06 ET 
Proposal SEALED

 United Kingdom  |  
IT Consultant based in Scotland
8
  |  
 5.0   |  $6,725 Earnings   |  20 Jobs
Bid ID: 38718828  |  Submitted: Mar 7, 2013 03:25 ET 
Proposal SEALED

 India  |  
An enthusiast web designer-developer always excited to build better web apps. Designing: -Photoshop -HTML5 -CSS3 -Twitter Bootstrap -Responsive...
9
  |  
 5.0   |  Private   |  10 Jobs
Bid ID: 38716793  |  Submitted: Mar 7, 2013 02:24 ET 
Proposal SEALED

 India  |  
Ready for any work in php cake, zend frame work, javascript, jquery, html and css
6
  |  
 5.0   |  Private   |  10 Jobs
Bid ID: 38710927  |  Submitted: Mar 6, 2013 23:49 ET 
Proposal SEALED

 United States  |  
I have 8 years of enterprise development experience. I have extensive experience with Java, PHP, Perl, Android SDK, MySQL, HTML, CSS, JavaScript....
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 38710392  |  Submitted: Mar 6, 2013 23:30 ET 
Proposal SEALED

 Argentina  |  
Winner
Computer engineer with more than 10 years of work experience. * Highly skilled with SQL, and I have worked using Microsoft SQL Server and MySQL...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 38708028  |  Submitted: Mar 6, 2013 22:00 ET 
Delivery
Within 1 day
$20.00

Sadia W.      
Sadia W.'s identity has been verified.  Learn More
 Australia  |  
I have seven years experience of working as a team member in software,database and website design, development and testing using Microsoft .NET...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 38706117  |  Submitted: Mar 6, 2013 20:48 ET 
Proposal SEALED

Getting things well done. I am a 11 years experienced web and software developer. After a second level degree in engineering took at “Politecnico...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 38704247  |  Submitted: Mar 6, 2013 19:20 ET 
Proposal SEALED
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 »