[firebird-support] View output differs from straight SELECT output

2012-10-23 Thread Reinier Olislagers
Hi list, Firebird 2.5RC3 (Debian version) on Debian Squeeze Trying to calculate percentages and totals (and hoping I'm getting the expression right): SELECT runs.id, count(rv.name), ((count(tr.resultvalue))*100)/(SELECT COUNT(resultvalue) FROM testresults where testresults.testrun=runs.id) from t

Re: [firebird-support] View output differs from straight SELECT output

2012-10-23 Thread Thomas Steinmaurer
> Firebird 2.5RC3 (Debian version) on Debian Squeeze > > Trying to calculate percentages and totals (and hoping I'm getting the > expression right): > SELECT runs.id, count(rv.name), > ((count(tr.resultvalue))*100)/(SELECT COUNT(resultvalue) FROM > testresults where testresults.testrun=runs.id) > f