Discoverer Help needed
From: Jim Wolfe <jim_wolfe_at_sra.com>
Date: Thu, 29 Mar 2001 14:09:28 GMT
Message-ID: <smHw6.11767$Uw.662585_at_newsread1.prod.itd.earthlink.net>
Date: Thu, 29 Mar 2001 14:09:28 GMT
Message-ID: <smHw6.11767$Uw.662585_at_newsread1.prod.itd.earthlink.net>
[Quoted] [Quoted] I'm fairly new to Discoverer and am trying to implement a SQL query using this tool. Is there a way for discoverer to implement a query of the following form?
select count(distinct field1), field2
from table
group by field2
I know I could create a view implementing this query then use Discoverer
query the view, but that pretty much defeats the purpose of the tool.
Thanks
Jim Wolfe
jim_wolfe_at_sra.com
Received on Thu Mar 29 2001 - 16:09:28 CEST