title: SQL Select With Multiple References to Single Table
body: <p>I have a SQL DB that contains multiple relational tables.  There are some fields in the master table that reference another table multiple times.  For example, say I have a database of salesmen who are responsible of sales for multiple states.  My database has fields for State1, State2, and State3 all of which map back to a States table.  I can't figure out for the life of me how to write a query to return a record with all the enumerated states.  If I only needed one State field, I know I would do:</p>
  
  <pre><code>SELECT Master.Name, State.Enumeration AS 'State'
  FROM MasterTable Master, StateTable State
  WHERE Master.State1 = State.ID;
  </code></pre>
  
  <p>How can I expand this for all my State fields?</p>
  
  <p>Thanks.</p>