Complex Query

Closed Posted Apr 27, 2010 Paid on delivery
Closed Paid on delivery

Thank you very much for your response. What I need developed is a more specific and highly advanced query. I need the query to match things from two different fields. Column 1 2 and 3 will be a column of cds that the person has. Column 4 5 and 6 will be the names of the CDs that the user needs. The purpose of this database is to search( in the order of the date each person submitted data )and then match customer ones needs to the needs of customer number two. The only results that are wanted from this are the ones that are capable of a swap matching scheme.

For instance... If customer one has in his column 1 that he has the beatles album, but column number 4 says that he needs the rolling stones, then it will match him with customer number 7 who has rolling stones but needs the beatles. It is an even trade.

Next example is that the same customer number one has the Journey CD written in his column of cds that he has in column 2. Column 5 says that he needs the Temptations album. The results from the advanced query show that Customer 9 has a need for Journey CD and is willing to trade his tempations CD. This is another fair trade.

This is all a complex query to matching (fair trades starting with the needs of the first posted). The data is placed in a query table. Then, the left over data can be matched with a more simple query scheme that does not require a trade.

MySQL

Project ID: #671424

About the project

15 proposals Remote project Active Jun 1, 2010

15 freelancers are bidding on average $106 for this job

donnykurnia

Hi, I'm sending more information via PM. Thanks.

$222 USD in 2 days
(13 Reviews)
3.9
kommandant

i can help you to achieve your goals

$100 USD in 3 days
(8 Reviews)
3.8
dilipkumarj

We are strong in Mysql.... try us

$200 USD in 3 days
(0 Reviews)
0.0
argenix

I'm ready to work with you in this project. I can do this query, just give me a sample data and I will work over there. Thanks

$100 USD in 1 day
(0 Reviews)
0.0
AndrewSergeichuk

Working with MySql already for 2 years. I have few rest-days, so I can do this very quickly.

$150 USD in 2 days
(0 Reviews)
0.0
layfeeling

Trust us. We can do this job right now !!!

$75 USD in 1 day
(0 Reviews)
0.0
gllphillips

Please Check the PMB

$30 USD in 0 days
(0 Reviews)
0.0
softdare

Hi, We read your description about what you need in this project and understand all of that, and what query you need. For more info, Just refer to your PMB. Thanks, Have Good time.

$160 USD in 2 days
(0 Reviews)
0.0
vlopes777

Hi there I can do this type of work...I'm a programmer for more than 12 years...count me in Send me a example to start this for you Thanks in advanced

$100 USD in 3 days
(0 Reviews)
0.0
webapps

I have 11 years experience in MySql SQL programing. Please see PMB for more information

$140 USD in 2 days
(0 Reviews)
0.0
alokemscit

Dear sir, I am Interested to complete your project. I have overall experience on MySql/SQL database, So I must complete your project Efficiently. Thanks.

$30 USD in 3 days
(0 Reviews)
0.0
OnDotWeb

Hi, Please check PMB. Thanks

$100 USD in 2 days
(0 Reviews)
0.0
shonjeo

please send me some sample data so i complete it and show to you. i have experience in mysql queries. i shall try my best to complete it quickly. thanks

$100 USD in 1 day
(1 Review)
0.0
barjak

Please check your PMB

$40 USD in 1 day
(0 Reviews)
0.0