title: Performing Inner Join for Multiple Columns in the Same Table
body: <p>I have a scenario which I'm a bit stuck on. Let's say I have a survey about colors, and I have one table for the color data, and another for people's answers.</p>
  
  <p>tbColors</p>
  
  <pre><code>color_code , color_name
       1     , 'blue'
       2     , 'green'
       3     , 'yellow'
       4     , 'red'
  </code></pre>
  
  <p>tbAnswers</p>
  
  <pre><code>answer_id  ,  favorite_color   ,   least_favorite_color   ,  color_im_allergic_to
      1      ,         1          ,         2                            3  
      2      ,         3          ,         1                            4
      3      ,         1          ,         1                            2
      4      ,         2          ,         3                            4
  </code></pre>
  
  <p>For display I want to write a SELECT that presents the answers table but using the color_name column from tbColors.</p>
  
  <p>I understand the "most stupid" way to do it: naming tbColors three times in the FROM section, using a different alias for each column to replace.</p>
  
  <p>How would a non-stupid way look?</p>