Appending Columns

[Dominato]

I have two unrelated tables that have an equal number of records. I need a query that will just show the columns of the first next to the columns of the second.

Example:
Table A
1 2 3
1 2 3

Table B
4 5 6
4 5 6

RESULT
1 2 3 4 5 6
1 2 3 4 5 6


[This message has been edited by Dominato (edited 04-11-2002).]

 

[Pat Hartman]

You need a common field to join on. You can add an autonumber field to each table that will assign a sequential number to each row and then join on the two autonumbers. I can't guarentee that this will work the way you want it to. There is not much sense in joining unrelated tables so I suppose it doesn't matter which row in tblA gets joined to a particular row in tblB.