title: How join two tables using SQL without a common column
body: <p>Example:</p>
  
  <p>Table 1:</p>
  
  <pre><code>Column1           Column2
  -----------       -------------
  A                 1
  B                 2
  D                 3
  E                 4
  </code></pre>
  
  <p>Table 2:</p>
  
  <pre><code>Column3           Column4
  -----------       -------------
  A                 7
  E                 9
  Z                 5
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>Column1           Column2             Column3            Column4
  -----------       -------------       -------------      -------------
  A                 1                   A                  7
  B                 2                   E                  9
  D                 3                   Z                  5
  E                 4                   NULL               NULL
  </code></pre>
  
  <p>I want the output as shown in the picture. </p>
  
  <p>If there are two tables with the columns Column1, Coumn2 and Column3, Column4,
  then the expected output should be Column1, Column2, Column3, Column4, without any joins. It should have Table2's columns to the right hand side of the Table1's columns. NULL values will consume the empty rows if the number of rows in each table don't match.</p>