Thread: query help

hi i am trying to execute the following query:

select source,(b.source/c.total),(select count(*) from entries b where
source = a.source) as source,(select count(*) from entries c) as total from
entries a group by source;


it says
ERROR:  Relation "b" does not exist


the query:
select source,(select count(*) from entries where source = a.source) as
source,(select count(*) from entries) as total from entries a group by
source;

works fine but i want to use the result from source and entries to work out
a percentage in the sql query
could someone point me in the right direction?

Thanks!

Rob

On Wed, 14 May 2003, Rob Larter wrote:

> hi i am trying to execute the following query:
>
> select source,(b.source/c.total),(select count(*) from entries b where
> source = a.source) as source,(select count(*) from entries c) as total from
> entries a group by source;
>
> it says
> ERROR:  Relation "b" does not exist

Right, because it doesn't escape the subselect.

Maybe something like:
select source, ecount/etotalcount, ecount as source, etotalcount as total
from
 (select source, count(*) as ecount from entries group by source) as t,
 (select count(*) as etotalcount from entries) as t1;