title: sql server join table with translation table
body: <p>I have two tables as such:</p>
  
  <pre><code>ID   Name    indicator_1   indicator_2
  1    text         1               1
  2    text         1               1
  3    text         1               1
  4    text         2               1
  5    text         2               1
  6    text         2               2
  7    text         2               2
  8    text         3               2
  
  FieldName    Value    Description
  indicator_1    1         good
  indicator_1    2         medium
  indicator_1    3         bad
  indicator_2    1         yes
  indicator_2    2         no
  </code></pre>
  
  <p>Is there any way to join the two tables and arrive at:</p>
  
  <pre><code>ID   Name    indicator_1   indicator_2
  1    text         good               yes
  2    text         good               yes
  3    text         good               yes
  4    text         medium             yes
  5    text         medium             yes
  6    text         medium             no
  7    text         medium             no
  8    text         bad                no
  </code></pre>
  
  <p>This is just a sample, the actual table has about 70 indicators...thanks much</p>