> (Actually, I've never tried using DISTINCT with UNION statements,

just hope it works - for all I know, it might even be redundant)

'Distinct' with 'union' is theoretically redundant. 'Union' returns
only unique records across the entire set (including the subsets you
put the distinct clause in).

Adam