Fill a column from multiple tables

mjcaestecker

Registered User.
Local time
Today, 13:20
Joined
Aug 17, 2012
Messages
25
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 :D
 
Yup, they're called Union Queries:

select * from table1 union select * from table2
 
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
 
Alright, that's fine. You've got the solution by G37Sam and bob fitz.
 

Users who are viewing this thread

Back
Top Bottom