title: Select from two tables which have no relation
body: <p>I don't know if it is possible or not. If possible, please help me to resolve this.</p>
  
  <p>I have two tables, <code>table1</code> and <code>table2</code>:</p>
  
  <pre><code>        table1                                table2
   column1     column2                column3            column4      
      1           2                      A                   B              
      3           4                      C                   D
  </code></pre>
  
  <p>There is no relation between <code>table1</code> and <code>table2</code>. I want to execute a query so that my output looks like this:</p>
  
  <p><strong>Output table</strong>:</p>
  
  <pre><code>  column1      column2       column3       column4
       1            2             A             B
       1            2             C             D
       3            4             A             B
       3            4             C             D
  </code></pre>
  
  <p>Can anyone please tell me how can I achieve this? We are using SQL Server 2005.</p>
  
  <p>Thanks,
  Kartic</p>