> 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 :-)