I want to send an email to a person assigned to interview a candidate. The candidates are in one table and the interviewer with their email addresses are in another table in the same base. The trigger is when an interviewer is assigned (the field is ...