Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Rozema Combining union and union all RE: Combining union and union all

  • March 8, 2012 at 2:23 am

    #1456404

    tim.kay (3/8/2012)

    Got it right and thought that I understood - now looking at the other posts I am slightly confused.

    So am I, as I was very sure I had tested both situations: union followed by union all and union all followed by union... I see what happens, but it contradicts with my previous results. So I need to find out what I did wrong previously.


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?