select email addresses and related beans.

If you want to return the owner records of the email addresses within SuiteCRM you can do this using the following.

 

SELECT * FROM `email_addresses` LEFT JOIN email_addr_bean_rel eabr on eabr.email_address_id = email_addresses.id