Let's say I have two tables with the follwing data:
Table_X
A | B
---------
1 | Cat
2 | Dog
3 | Mouse
4 | Hat
Table_Y
C | D
---------
2 | Eat
4 | Book
I would like a select statement that joins these two tables to produce the
following. It lines up the rows one by one against one another simply by
the order they appear in the table, but not by any other criteria:
View_XY
A | B | C | D
----------------------------
1 | Cat | 2 | Eat
2 | Dog | 4 | Book
3 | Mouse | |
4 | Hat | |
Any ideas?
Thank you,
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------