Mysql query

CB doesn't store names in jos_comprofiler, only data.. Names are stored in jos_users..

How do write a SQL query to display the data below with the condition (WHERE) cb_sex = male.. I believe I need to use a join command?

ID, NAME, cb_address, cb_postcode, cb_sex
123, John Doe, 25th Avenue, 564VBG, male

You don't need a query field for this at all. Just use a delimiter field. Example as follows.

[cb:if cb_sex="male"]
[user_id], [name], [cb_address], [cb_postcode], [cb_sex]
123, John Doe, 25th Avenue, 564VBG, male
[/cb:if]

You can find more on substitution usage at the below tutorial.

www.allmysocials.com/directory/tutorials/item/233-substitution-usage

Aside from that no, you don't need to do a JOIN; just concat firstname, middlename, and lastname to give you name. You can also use [name] directly in your query if you wanted.

Sorry I think my question wasn't clear.

I need to do a query as I need to generate a list of users on my site.. and the thing is that the names and data is on different table..

I need to do a MYSQL query and export it to MS Excel..

So i am working something like:

SELECT `id` , `NAME` , `cb_addressline1` , `cb_addressline2` , `cb_postcode` , `cb_town` , `cb_state` , `cb_telephone`
FROM `jos_comprofiler` , `jos_users`
WHERE `cb_postcode` = 'XYZ123'

Can seem to get it right..

I tried something like this too..

SELECT `jos_users.id` , `jos_comprofiler.id`
FROM `jos_users` JOIN `jos_comprofiler`
ON jos_users.id = jos_comprofiler.meterid
GROUP BY jos_user.meterid

You can CONCAT_WS the first, middle, and last names or JOIN the _users table. See the below SQL tutorial regarding JOINs.

www.w3schools.com/sql/sql_join.asp

See the below MYSQL documentation for CONCAT_WS usage.

dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_concat-ws