Find a contact's email address in the database

Hello.  I'm trying to do some queries on the database for some external reporting.  The contacts table does not contain an email address column.  There is however an email_addresses table.  Though I don't see anything that links these email addresses back up with anything from the contact table.