SQL Help

Hi Community,
I wonder could someone help me with an SQL query! Heres what im trying to do... print to a webpage all member names and the value of the following custom fields.. cb_racedate, cb_position,cb_racename,cb_racetime. So a line on my page will look something like this:

Name Date Pos Race Name Time
John Smith 12/2/10 3 New York race 3.33
Pat Reilly 22/6/10 5 Chicago race 2.33

I was hoping someone might be able to give me the query so I don't have to spend the next couple of days learning SQL... its on my todo list but im pressed right now.
I think I can figure out the PHP but so just the query would be fantastic.

Thanks community. Rob

Believe this should be a simple select query if that's what you're wanting. Of course you'd need to output it as an object/array if you intend to use it in PHP. Query is as follows.

[code:1]
SELECT b.`name` AS 'Name'
, a.`cb_racedate` AS 'Date'
, a.`cb_position` AS 'Pos'
, a.`cb_racename` AS 'Race'
, a.`cb_racetime` AS 'Time'
FROM `#__comprofiler` AS a
LEFT JOIN `#__users` AS b
ON a.`user_id` = b.`id`
[/code:1]

If you need formatting of course that'd need to be done with a more complex query. You can find information on MYSQL queries for formatting results here . You can also find some great SQL tutorials here .

Thanks so much! That really helped. Anyone following me in my footsteps I had to rename the tables in my query to jos_ instead of #___

Ive also since stopped being a girly man and went and learned my php/sql... well im in the process anyway I can recommend http://www.tizag.com/sqlTutorial/ to others.