title: multiplication table sql
body: <p>How is it possible to create a SELECT query that will output <a href="http://i.stack.imgur.com/giBMZ.png" rel="nofollow">multiplication table</a>
  without using anything like join or subqueries? One may use some new supporting tables.</p>
  
  <p><strong>upd:</strong></p>
  
  <pre><code>select 
  x " ",
  x*x1 "1", x*x2 "2", x*x3 "3", x*x4 "4", x*x5 "5", x*x6 "6", x*x7 "7", x*x8 "8", x*x9 "9",        x*x10 "10"
  from num, res
  where rownum &lt; 11;
  </code></pre>