Jointing fields from 2 (or more) tables into one table in Access 03

Status
Not open for further replies.

pioneerx01

Posts: 279   +2
Hello,

I have multiple tables that has info as such:

table_1:
f_name | l_name
bob | simth
john | doe

Than I have another table (same database)
table_2:
f_name | l_name
mike | brown
me | stupid

How do I combine them so I get:
table_All:
f_name | l_name
bob | simth
john | doe
mike | brown
me | stupid

Any help is appreciated
 
Status
Not open for further replies.
Back