Show email using SQL Query

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi all,

I try to show email_address in query but not showing up, how to make query to show email address ?

My SQL Query :
SELECT
leads.id,
leads.first_name,
leads.last_name,
leads.phone_home,
leads.phone_mobile,
leads.phone_work,
leads.phone_other,
leads_cstm.country_c,
email_addresses.email_address
FROM
leads
LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c
LEFT JOIN email_addresses ON email_addresses.id = leads.id
WHERE leads.deleted = 0

Please need help

2

Email addresses are stored in email_adresses but the relation between them and modules are stored in email_addr_bean_rel

best regards

2 Likes