title: Mysql joining the same table into multiple columns (denormalizing?)
body: <p>I'm going to simplify my real tables to ask this question
  Postulating the following normalized tables</p>
  
  <h2>    Soda</h2>
  
  <pre><code>idSoda
  sodaName
  </code></pre>
  
  <h2>    Flavor</h2>
  
  <pre><code>idFlavor
  FlavorText
  </code></pre>
  
  <h2>    SodaFlavorAsc</h2>
  
  <pre><code>SodaID
  FlavorID
  </code></pre>
  
  <p>Assuming that sodas can have more than one flavor (up to three), how do I create a query that denormalizes the data back into one flat table?</p>
  
  <pre><code>idSoda, sodaName, FlavorText(first occurance), FlavorText(second occurance), FlavorText(third occurance)
  </code></pre>