SQL query for contact emails in Zucker Reports

[nvdp2002]

Version 5.0.0f (Build 3338)
MSSQL express 2005
Windows 2003 server

Hi ive been trying to run a sequel query in zucker to retrieve the email addressess next to contact names. I just can’t seem to find the link though.

If anyone can help it would be much appreciated

Thank you,
Nasser

[nvdp2002]

any one who knows the database structure should be able to help with this

[jbmdn]

Maybe this helps:

SELECT distinct c.last_name, c.first_name, e.email_address, a.name as copmpany_name
FROM contacts c LEFT JOIN (accounts_contacts ac, accounts a, email_addr_bean_rel erel, email_addresses e)
     ON (ac.contact_id=c.id AND ac.account_id=a.id AND erel.bean_id=c.id AND e.id=erel.email_address_id)
where c.deleted=0
group by c.id
order by c.last_name

best regards,
jbmdn