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;