Re: need some more select help

> As the error indicates, you must give an alias for subquery
>
> select a,count(1) FROM (select a from X UNION select a from Y ) as
> your_alias_name group by a;

Ohh, I see. I completly misunderstood it earlier.
Thanks for clearing that up :-)