email field location in database

Hi everyone,

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?

Thanks!
H.

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):