title: How to join two tables without any condition
body: <p>For example I have two tables (temp tables). One of them contains only IDs, and the other contains real information. They have exactly the same row number.</p>
  
  <pre><code>#Table1
  ID
  14
  15
  16
  
  #Table2
  CarModel    Year
  Ford        1996
  Ferrari     2005
  Toyota      2010
  </code></pre>
  
  <p>How can I join this two table in one (without any condition, just the result table has 3 columns, no matter in what order)? I need it for inserting the result for real table</p>
  
  <pre><code>Cars
  ID   CarModel   Year
  </code></pre>
  
  <p>And this table doesn't use identity. There is an own mechanism of getting IDs for inserting.
  I'm not able to change it.</p>
  
  <p>So as a result I need a table like one of the following (ordering is NOT important):</p>
  
  <pre><code>#Table3
  ID   CarModel    Year
  14   Ford        1996
  15   Ferrari     2005
  16   Toyota      2010
  </code></pre>
  
  <p>or</p>
  
  <pre><code>#Table3
  ID   CarModel    Year
  16   Ford        1996
  14   Toyota      2010
  15   Ferrari     2005
  </code></pre>
  
  <p>P.S. I understand how to do this with CTE and row_number(), but I think there is more easier way to do this task. And may be this code will be used in MS SQL Server 2000, so I will be glad to look at other variants of the solutions.</p>