combining two single-column tables into one two-column table

[oilcorner]

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.

[pbaldy]

The only way I can think of to do it would be to impose a relationship. Add a numeric column to both tables and number the records 1-5 in each. Then you have a field you can join on in a query.

[dblife]

if 'apple' and 'monkey' shared the same foreign key, i imagine there would be a way to employ a union query with some concatenation...

[oilcorner]

Thanks very much to both of you for taking the time to answer. I'm a little too beginner to fully understand dblife's answer, but I think I will give pbaldy's suggestion a go tomorrow.

[dblife]

it's the same as pbaldy's but they had the sense to express it more simply...

[oilcorner]

It's working great, thanks a lot

[pbaldy]

Happy to help!