• Without any DDL, and little explanation, this a bit of a guess, however, have a look at UNION and UNION ALL.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk