Adam,

> 'Union' returns
> only unique records across the entire set (including the subsets you
> put the distinct clause in).

Don't forget that "UNION ALL" does NOT remove duplicates.


Sean