Fill a column from multiple tables

[mjcaestecker]

Greetings all,

Is it possible to have one column that has results in it from two tables??

for example:
in column 1:
A
B
C
D
E

and in column 2 (from another table)
F
G
H

can I have a column created by sql that puts the two together as
A
B
C
D
E
F
G
H


Thanks for the help

 

[bob fitz]

I think you can do this with a Union query. This link may be of help: http://rogersaccessblog.blogspot.co.uk/2010/02/union-query-part-1.html

 

[G37Sam]

Yup, they're called Union Queries:

select * from table1 union select * from table2

 

[vbaInet]

I just wonder what your table structure is like.

 

[mjcaestecker]

What I'm trying to do is somewhat strange, yes... There's a table with the names of our company's staff and another table with a list of the owners of the company. i was just trying to merge the two into one dropdown box so any of their names could be selected from one place - without much luck, i might add

 

[vbaInet]

Alright, that's fine. You've got the solution by G37Sam and bob fitz.