Hi all,
I'm new here and and this is probably a silly question, but please bear with me
I'm trying to do something that one would normally never want to do for any reason I can think of, but I still really want to do it. Let's say I have two tables: table1 and table2. Both have exactly the same number of rows and only one column. For example:
Table1:
-------
apple
pear
banana
orange
grapefruit
Table2:
-------
monkey
lion
bear
dog
mouse
Now I'd like to combine them into the following table with two columns:
Table3:
--------
apple monkey
pear lion
banana bear
orange dog
grapefruit mouse
So basically, just glue the two together. The tables have no obvious relationships or anything, and it's kinda hard to explain why I would ever want to do this, but still.... I can't seem to find out how to do this? It seems like it should be very simple (and it probably is). Could you please help me out..?
Thanks a lot in advance.