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;