title: How to join two tables together with same number of rows by their order
body: <p>I am using SQL2000 and I would like to join two table together based on their positions</p>
  
  <p>For example consider the following 2 tables:</p>
  
  <pre>
  table1
  -------
  name
  -------
  'cat'
  'dog'
  'mouse'
  
  table2
  ------
  cost
  ------
  23
  13
  25
  </pre>
  
  <p>I would now like to blindly join the two table together as follows based on their order not on a matching columns (I can also guarantee both tables have the same number of rows):</p>
  
  <pre>
  -------|-----
  name   |cost
  -------|------
  'cat'  |23
  'dog'  |13
  'mouse'|25
  </pre>
  
  <p>Is this possible in a T-SQL select??</p>