I am writing a companion system that uses the Sugar database. I need to retrieve a user's email address. I am having some difficulty finding the path that gets me from a users table to the email_addresses table. I am missing something in between that links the user row with the email_addresses row.
Anyone got any ideas?