title: Multiple foreign keys from one table linking to single primary key in second table
body: <p>I have a database with three tables, a household table, an adults table and a users table. The Household table contains two foreign keys, iAdult1ID and iAdult2ID. The Users table has a iUserID primary key and the Adult table has a corresponding iUserID foreign key.  One of the columns in the Users table is strUsername, an e-mail address.</p>
  
  <p>I am trying to write a query that will allow me to search for an e-mail address for either adult that has a relation to the household. So I have two questions, assuming that all the values are not null, how can I do this?</p>
  
  <p>And two, in reality, iAdult2ID can be null, is it still possible to write a query to do this?</p>
  
  <p>Thanks for your help.  Let me know if you need any more information.</p>