Thanks so much! it's exactly what I needed (although without the "ALL" - to not have duplicates)
It's those usefull T-SQL stuff that are so elusive sometimes.
I should really slap myself for:
a. not knowing this operator before
b. for not reading the SELECT specification carefully enough
I was already thinking to a level of having to create a Temporary Table and Inserting values into it...