Union query with identical queries

Posted on 2011-05-04
Last Modified: 2012-05-11
Just as a curiosity, can you tell me why if I Union two identical MS Access Queries I don't get double the same results? Is there a particular reason why the union only works for combining queries that are different?
Question by:joeserrone
    LVL 119

    Accepted Solution

    using Union All will give you duplicates
    using Union  , no duplicates
    LVL 119

    Expert Comment

    by:Rey Obrero
    select f1,f2 from A
    Union All
    select f1,f2 from A

    will give you duplicate values

    select f1,f2 from A
    select f1,f2 from A

    no duplicate values

    Author Comment

    Thanks, I completely forgot about Union All

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now