title: Possible to name table from value from a field of another table
body: <p>Is it possible to name a table from a value from a column of a different table.</p>
  
  <p><strong>Example</strong>:</p>
  
  <pre><code>Select a from dbo.[(select x of dbo.food where x=Candy)]
  </code></pre>
  
  <p>Other Table: <code>dbo.Food</code></p>
  
  <pre><code>  X      Y       Z 
  --------------------
  Candy  Apples  Pears
  --------------------
  </code></pre>
  
  <p>I am trying to append the value from another table as a new table <code>dbo.candy</code></p>