title: MySQL Dual table Join Dual table
body: <p>Is there a way to JOIN fields from the dummy DUAL table in MySQL?</p>
  
  <p>Say I have a</p>
  
  <pre><code>SELECT 1 as n1 FROM DUAL
  
  n1
  --
   1
  </code></pre>
  
  <p>and a</p>
  
  <pre><code>SELECT 2 as n2 FROM DUAL
  
  n2
  --
   2
  </code></pre>
  
  <p>Can I join both selects with a Join in some kind of query as...</p>
  
  <pre><code>SELECT 1 as n1 FROM DUAL JOIN (SELECT 2 as n2 FROM DUAL) ON 1=1
  </code></pre>
  
  <p>?</p>