• Thanks Greg.

    Copied and ran all your sample code, conclusion - makes understanding the various operators (EXCEPT, INTERSECT, UNION and UNION ALL ) exceptionally clear.

    And the additional tidbits of information such as:

    In addition, something worth noting is that the column headers displayed take the names associated with the columns identified in the first SELECT.

    Definitely a "must read" for newbies to SQL.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]