Displaying 1 result from an estimated 1 matches for "dev_tot".
Did you mean:
dev_t
2006 Apr 11
1
Ad hoc query from derived view
...a query that uses a derived view (see below) and
am wondering how return the data. I don''t have a model for this, so I not
sure if find_by_sql can be used. Any help is greatly appreciated.
select product
,mailer
,sum(dev_total) dev
,sum(qa_total) qa
,sum(verified_total) verified
from (select product
,mailer
,count(1) dev_total
,0 qa_total...