> Also, a common gotcha when UNIONing is that it works a little
> differently to
> a non-UNION SELECT. UNIONs return a DISTINCT result set by default, so I
> suggest that you might want to use the ALL predicate, eg,
>
> SELECT ....
> FROM ...
> UNION ALL
> SELECT ....
> FROM ...
> GROUP BY ...
>
> Regards,
>
> Darryl

You just lurk there don't you Darryl
Alan