title: How do you input multiple SELECT outputs into a FROM clause in MySQL?
body: <p>I want to do something similar to the following in MySQL, but every permutation I try gives me errors.  </p>
  
  <pre><code>SELECT five,six FROM (SELECT 5 AS five),(SELECT 6 AS six);
  </code></pre>
  
  <p>I was under the impression that SELECT's output table's, so that I could use SELECT whereever I could insert a table.</p>
  
  <p>Can someone explain the subtleties of the structre of MySQL that prevents this statement from working as well as providing me a solution that does?</p>
  
  <p>I know that it's got to be simple, but I haven't been able to find an answer to this anywhere.</p>