I am using SQL2000 and I would like to join two table together based on their positions
For example consider the following 2 tables:
table1 ------- name ------- 'cat' 'dog' 'mouse' table2 ------ cost ------ 23 13 25
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):
-------|----- name |cost -------|------ 'cat' |23 'dog' |13 'mouse'|25
Is this possible in a T-SQL select??