Complex Query
$30-250 USD
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.
Project ID: #671424
About the project
15 freelancers are bidding on average $106 for this job
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
Working with MySql already for 2 years. I have few rest-days, so I can do this very quickly.
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.
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
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.
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