TechSpot

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

By pioneerx01
Sep 26, 2008
  1. 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
     
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.