title: SQL Server - Insert into a combination of two tables
body: <p>I need to combinate two tables in SQL Server. But I need to have a row with each item of table A with each item of table B, resulting in a table C. I would be like this:</p>
  
  <pre><code>Table A
  A
  B
  C
  D
  
  Table B
  1
  2
  3
  
  Table C
  column x | cloumn Y
     A           1
     A           2
     A           3
     B           1
     B           2 
     B           3
     C           1
     C           2
     C           3
     D           1
     D           2
     D           3
  </code></pre>
  
  <p>Thanks all!</p>