Re: need some more select help

Hello,

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;

On Fri, Jul 17, 2009 at 1:53 PM, A B <gentosaker(at)gmail(dot)com> wrote:

> I'm trying to
>
> select a,count(1) FROM (select a from X UNION select a from Y ) group by a;
>
> but it complains and says that the subquery must have an alias and I
> have not figured it out how to add that.
>
> Btw. is there any other way of doing what I'm doing above?
>
> It's basically select a,count(1) from X group by a + select
> a,count(1) from Y group by a where "+" means they should be summed
> on the "a" field.
>
> I tried
> select a,sum(b) from ( select a,count(1) as b from X group by a
> union select a,count(1) as b from Y group by a) group by a
>
> but that gave also an error asking for an alias for the subquery.
>
> How can I solv this problem?
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

--
.regards
.thara s pillai