title: Creating a New Column in one Table Based on the Query of Another Table
body: <p>I have a Database that has a Materials Table. I need to create a NEW table where the Materials.Refines_To Rows are now Columns from the original.</p>
  
  <p>Example:</p>
  
  <pre><code>MATERIALS TABLE
  ID    NAME    REFINES_TO
  1     Ore1      Nuggets
  2     Ore2      Simple Paste
  
  NEW TABLE
  ID   "in this case Nuggets"   "Simple Paste"
  1              5                    2
  </code></pre>
  
  <p>This way I can reference what Materials are needed for a crafting item in another Table later.Only need to create the New table once. I can append to it any new materials later as they are created.</p>
  
  <p>Thank You</p>