At 09:57 AM 14/03/2008, Sean wrote:

>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.

But UNION ALL is not UNION. The default for UNION is UNION DISTINCT. We've even got explicit UNION DISTINCT syntax, a la SQL-99, introduced from Fb 2.0 onward.

./heLen