title: sql to combine two unrelated tables into one
body: <p>I have tables</p>
  
  <p>table1</p>
  
  <pre><code>col1    col2    
  a       b
  c       d
  </code></pre>
  
  <p>and table2</p>
  
  <pre><code>mycol1  mycol2
  e           f
  g           h
  i           j
  k           l
  </code></pre>
  
  <p>I want to combine the two tables, which have no common field into one table looking like:</p>
  
  <p>table 3</p>
  
  <pre><code>col1    col2    mycol1  mycol2
  a           b   e   f
  c           d   g   h
  null    null    i   j
  null    null    k   l
  </code></pre>
  
  <p>ie, it is like putting the two tables side by side.</p>
  
  <p>I'm stuck!  Please help!</p>