1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Windows Simple Access Query Help

Discussion in 'Software' started by jopers1986, 20 Oct 2009.

  1. jopers1986

    jopers1986 Member

    Joined:
    7 Jan 2005
    Posts:
    559
    Likes Received:
    4
    Hi,

    I want to make a report that shows all the information in 2 tables.

    table one has processing info

    table two has packing info,

    they both have the same structure, just slightly different primary keys.

    I want to create a query that will list all the data from table one, then under it, list all the info from table two...

    Is this possibe?

    Thanks

    Rich
     
  2. Daedelus

    Daedelus New Member

    Joined:
    7 May 2009
    Posts:
    253
    Likes Received:
    12
    SELECT column_name(s) FROM table_name1
    UNION ALL
    SELECT column_name(s) FROM table_name2

    The column names you choose need to be the same from each table but you can use aliases e.g.

    SELECT fname as NAME, sname as SURNAME FROM names
    UNION ALL
    SELECT NAME, SURNAME FROM customers
     
    thehippoz likes this.
  3. jopers1986

    jopers1986 Member

    Joined:
    7 Jan 2005
    Posts:
    559
    Likes Received:
    4
    Ah nice and easy! thanks for the help Daedelus!

    Rich
     

Share This Page