For my client I'm pulling some data out of the _comprofiler table in my database (all the relevant subscription fields).
Question: I don't see 'email' (primary email adress) between the rows in the _comprofiler table. So does CB pull the email adresses out of the Joomla _users table ?
Anyway, it would be great to include the email data in one single user list (.csv via SQL query) amongst all other relevant fields for my client. Can this be done?
I started reading about SQL and learned how to join certain data from two different tables that share an identical row.
_comprofiler and _users share the id (user) so that makes it possible to link the primary email adress from _users to all the relevant entries in _comprofiler and build a new table.
The query looks like this (short version without a ton of cb_fields):
Code:
SELECT firstname, lastname, cb_mobile, jos_users.email
FROM `jos_comprofiler` JOIN `jos_users`
ON jos_comprofiler.id = jos_users.id
