Database query design and explanation

I have a database with information in several tables. I need to produce a 4 dimentional matrix (see below). Currently i use a series of inefficient queries and i need someone experienced in database query design to create efficient queries. The database is MySQL 5 and i use Java for application programming. ## Deliverables I am currently after a specific query ( or combination of queries ) but it is a situation that i encounter often so i need someone who is also able to explain how to approach database structure and query design. Please register your interest and be specific about your experience. If i feel you are suitable i will give you access to the actual database which is on-line. You will have ample opportunity to look at it before making a bid price. Please make a bid price for the required query(s) including some explanation. Also indicate an hourly rate should i require more extensive explaining. The matrix i need to produce consists of prices for betting opportunities. The colums consist of bookmaker prices, the rows are betting selections. An example of such a situation can be seen here: <[login to view URL]> The 4th dimension arises in handicap markets where the same bookmaker may offer several prices on the same selection including a score handicap. Example: <[login to view URL]> ( if these examples no longer exist by the time you read this then simply lookup other matches with "winner" and "asian handicap" markets ) I have tables for "market" ,"bookmaker"? , "selections" , "prices" , all can be linked using ID's in what i think is a fairly standard way. Again, if i feel you are suitable i will give you access to the actual database before you make a bid price. I need a query , or combination of queries and programming (Java only!), that is efficient and allows me to extract a full table. In case a bookmaker has multiple prices i want? these to appear as additional columns. ( so not as it's in the example, i want the bookmaker to? appear with multiple columns? ) - I understand that to obtain an efficient query i may need to change the structure of the database. - I understand i may need to combine multiple queries and possibly use some application programming in between. I'm currently producing a table by running each colum as an individual query filling array's as i go along. Highly in-efficient and there must be a better way. Any experience with Java serverside using Tomcat and JDBC will be a big plus.