> <cfquery name="PartyConstituencyResults" datasource="#request.datasource#">
>
> SELECT c.ConstituencyName, s.ConstituencyNo, v.Party, Sum(v.Votes) AS
> TotalVotes
> From (Constituency c
> INNER JOIN PollingStation s ON c.ConstituencyNo = s.ConstituencyNo)
> INNER JOIN VoteResults v ON s.AgentPhoneNo = v.AgentPhoneNo
> WHERE v.ResultCategory = 'L' AND s.ConstituencyNo IN (Select ConstituencyNo
> From Constituency)
> Group By c.ConstituencyName, s.ConstituencyNo, v.Party
> Order By c.ConstituencyName
>
> </cfquery>
After this query, add a query of query that gets the top 1 record sorted
by totalVotes desc:
<cfquery name="WinningConstituency" dbtype="query" maxrows="1">
select * from PartyConstituencyResults
order by TotalVotes desc
</cfquery>
That oughta do it. :)
hth
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 781.769.0723
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313001
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
