email address for contact different in reports

[hardysoft]

How does Sugar record email addresses in V5.0.0f and what joins are needed to produce an SQL report...?

As an example of our confusion, we have a contact that shows only one email address (which is correct). But when we run a Zuckerreport it prints a different address.

In the MySQL Contact table the incorrect address is displayed
in the Sugar Contact record the correct addess is displayed

There is another MySQL table called email_addresses and both these addresses appear in this table.

I am assuming that because there is a 1-many relationship between a contact and their email addresses these are held in a table outside of the contact table. Presumably the email_addresses table.

But how are these joined?
Why is there an email1 field in the contact table and how does it get populated?

Thanks in advance for anyones attention.

[crmsiva]

Hi

contacts -> email_addr_bean_rel -> email_addresses

This is how an email address is related to a contact in db