Combining two tables into one in the same database

Posted on 2009-12-22
Last Modified: 2012-05-08
How do I combine two tables (trans and trans1) that have the same structure into one table named trans using SQL statements? These tables are in the same MS Access database.
Question by:TrueBlue
    LVL 8

    Assisted Solution

    Select *
    FROM trans
    Select *
    From trans1
    LVL 84

    Accepted Solution

    If you truly want to combine them:

    INSERT INTO trans SELECT * FROM trans1

    Otherwise, if you just want to "view" them, use the UNION as suggested by MelMc

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now